eMail SQL Query Results

We have an SQL application that captues live data from communication sites. This is a mission critical application. We are currently using stored procedures to send eMail to us of small things, like records not being written into a table in the last 'x' minutes. What we want to do is have a machine query 4 other machines to check their health (quantity of records, last time a record was added, etc.) So far no problem. The issue seems to be that we cannot get the results of a query into an eMail or attached to an eMail that will come to our office. >>> UPDATE I've had MANY responses so far! This is great! I've been asked for a little further information--- This is MSSQL7 on NT, latest patch. I do NOT have a clean portal to the Internet to send mail, we are having to go through our client's eMail server (but we are already doing that in our simple version of what we're trying to accomplish) I'm turning over the responses to my Sr. Programmer for evaluation and movement. ## Deliverables I am the CEO of the company and thus do not have the details on what should be included in the deliverables. ## Deadline information ASAP