SQL Mail - xp_sendmail - Attachements
-
Hi !
I wonder if it's possible to do that :
In an e-mail send with xp_sendmail to attach more than one file; let's say i want 2 notification files : select * from Sales, Select * from User, etc.
Can i calculate this in temporary files (##x1, ##x2) and then send only 1 e-mail with 2 attached files ?
Any help will be appreciate. Pls tell even if u think this is not possible, will save my time to search.
Thank you.
-
Never tried xp_sendmail with two queries. Try seperating them with the semi-colon statement terminator and see what you get.
Personally I stay away from SQL Mail, too much of a hassle to keep running correctly. If Reporting Services isn't an option, I'd use sp_makewebtask to generate the files and xp_smtp_sendmail to send them out.
--------------------
Colt 45 - the original point and click interface
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply