Include query in body of email

[jsbarroso]

I have a query table in Access 2007 with requests pending an individual’s review and approval. I would like to create an automatic email each day to that individual which includes the actual query table impeded as part of the body of the email (not as an attachment). Any ideas?

Thank you in advance.

 

[pr2-eugin]

It will involve a bit of coding, to loop through the recordset, creating a table (in HTML ofcourse) then send that to the email.