email results of query as body text 1

[sedgely]

i have been tasked with sending out by email some performance figures on a regular basis. i have a stored proc that returns the figures and i know how to send them out as an attachment, but "they" want the figures as part of the email body text. does anyone know if this is possible and if so how do i go about doing it?

Cheers, Craig
Si fractum non sit, noli id reficere

 

[mutley1]

Hi Sedgley,

Are you using xp_sendmail? If so, add another parameter

@attach_results = 'false'

Cheers,

M.

 

[sedgely]

Thanks Mutley1 that did the trick. you can have a star for that - my headache has just disappeared

Cheers, Craig
Si fractum non sit, noli id reficere

 

[mutley1]

You're welcome, Craig!

BR

M.