I use database mail and attach the results of the query to the email. Though I suppose you could parse the query results into the body of the message....