passing a query to sp_send_cdosysmail

I am looking for any help or hints on how to pass a query into or run a query as sp_send_cdosysmail as the body.
I need some way other than using an attachment to return the results of a query from sp_send_cdosysmail as the body. Any good points in a direction would help!XP_sendmail [BOL]

This example sends the results of the sp_configure to Robert King.

EXEC xp_sendmail 'robertk', @.query = 'sp_configure'|||Only problem with that is we don't want to install outlook on every sql machine we have....

Originally posted by Ruprect
XP_sendmail [BOL]

This example sends the results of the sp_configure to Robert King.

EXEC xp_sendmail 'robertk', @.query = 'sp_configure'|||just curious
why not?

sql mail works really well. you dont have to load anything but outlook.
you could configure the msi with a transform file and deploy it with a group policy
you could set the profile with a vb script so all you would have to do is log on wait for the install to finish and log off.|||for the 16+ servers we would have to pay for an outlook license.

Originally posted by Ruprect
just curious
why not?

sql mail works really well. you dont have to load anything but outlook.
you could configure the msi with a transform file and deploy it with a group policy
you could set the profile with a vb script so all you would have to do is log on wait for the install to finish and log off.