December 2, 2008 at 2:14 am
Hi Guys,
back already!!!!!
Right.... i got the xp_sendmail function working and have started to have a play with the CDONTs functions which to my surprise I have managed to do and send a HTML bodied email from the SQL server without requiring Outlook to be installed on it, now to be a complete pain:
I want to be able to send the results from a working stored procedure as various attachments to this pretty HTML email that CDONTs produces. I have been able to send SP's as attachments using the xp_sendmail function which seems pretty straight forward but would like to use the CDONTs now as it seems like a more powerful way. The formats that I want to be able to attach are 1 SP to a csv file and 1 SP to a pdf file. They don't necessarily have to be on the same email but also is that possible?
😀
December 4, 2008 at 11:15 am
I do not remember where, but apparently CDOSYS is better than CDONT.
You can also use CDOSYS (Collaborative Data Objects).
You can find detail code example at http://www.sqlservercentral.com/Forums/Topic527864-110-1.aspx
One point worth mentioning: this does NOT require that Outlook be installed and running on the SQL Server host. And you do NOT have to configure a MAIL account in SQL Server either.
Regards
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply