Can query result be mailed with sp_send_cdosysmail?

• EA

  Mr or Mrs. 500

  Points: 521

  More actions

  July 28, 2006 at 1:49 am

  #173523

  Hi,

  I want to send the result of a query in the body of a mail message. I'm using sp_send_cdosysmail.

  How can I get the query result into the @body variable?

  Thanks in advance!

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  July 30, 2006 at 1:47 am

  #652247

  Search is your friend...

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=112330

  Andy