Post reply

SQL Mail - xp_sendmail - Attachements

  • September 19, 2005 at 12:54 am

    #110773

    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.

     

     

  • September 19, 2005 at 1:47 am

    #590845

    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