If the results of the query can be sent as the text of the email (in HTML), I highly suggest this stored procedure.

http://www.virtualobjectives.com.au/sqlserver/saving_to_html.htm

I've been using it for over...

At a previous employer, we played "donuts". If you walked away from your station and didn't lock it, then whoever noticed this would pop up a new email and send...