SQL Mail Help 2005

[mattm31]

Hi

Not sure if this is possiable but i want to
run a query and then dump the results into
the main body of an email.

I know you can do it with an attachment but i'd
prefer not to do it that way.

Thanks

Matt

 

[mattm31]

Just found the solution using XP_send in the FAQs

 

[RyanEK]

Hi,

If you're using SQL2005+ i suggest you use DBMail instead of SQL Mail. With DBMail there is no MS Outlook or extended MAPI requirements.

Ryan