Send Mail with Attach excel file using SQL EMail

Send Mail with Attach excel file using SQL EMail

23 Feb 2010 01:02:51
Hi I want to Generate excel file from SQl database using Query it may be morethen one then email this using SQl EMail with Attachment Thanks in advance Regards Kirti
Kirti.Darji.001
Expert   Boarder
Posts: 28
From 03-Jun-2009
You're Points: 538
Bookmark
Re:Send Mail with Attach excel file using SQL EMail23 Feb 2010 01:02:51
Hi Yes you can do in sql server with SqlMail Here step by step to do this [url]http://support.microsoft.com/kb/312839[/url] Thank you
RRaveen
Gold  Boarder
Posts: 156
From 03-Jun-2009
You're Points: 1106
Bookmark
Re:Send Mail with Attach excel file using SQL EMail23 Feb 2010 01:02:51
My SMTP server not Start following message come when i start IIS Configuration is require for Sending Mail using SQL [img size=448]http://www.codegain.com//images/fbfiles/images/111.JPG[/img] Any Example you Provide like take record from SQl--->insert into Excel then send Mail with attach File Regards Kirti
Kirti.Darji.001
Expert  Boarder
Posts: 28
From 03-Jun-2009
You're Points: 538
Bookmark
Re:Send Mail with Attach excel file using SQL EMail23 Feb 2010 01:02:51
Hi, To this you need check this work around to fix [url]http://support.microsoft.com/kb/886695[/url] Thank you
RRaveen
Gold  Boarder
Posts: 156
From 03-Jun-2009
You're Points: 1106
Bookmark
Re:Send Mail with Attach excel file using SQL EMail23 Feb 2010 01:02:51
Hi You Have any idea about DTS Package usefull for sending a maul Regards Kirti
Kirti.Darji.001
Expert  Boarder
Posts: 28
From 03-Jun-2009
You're Points: 538
Bookmark
Re:Send Mail with Attach excel file using SQL EMail23 Feb 2010 01:02:51
Hi in sql server 2005 you can use the SSIS package to send email.like this [url]http://dotnetslackers.com/articles/sql/UsingSQLServerIntegrationServicesSSIS.aspx[/url] this is also great way to send email(automatic emails) thank you
RRaveen
Gold  Boarder
Posts: 156
From 03-Jun-2009
You're Points: 1106
Bookmark
Re:Send Mail with Attach excel file using SQL EMail23 Feb 2010 01:02:51
Thanks keep it up
Kirti.Darji.001
Expert  Boarder
Posts: 28
From 03-Jun-2009
You're Points: 538
Bookmark
^ Scroll to Top