How to send an Email based on Query Results

[arich6211]

Hello, I am new to access. I am using it as an insurance tracker/maintenance contract tracker for tenants and vendors for real estate. I have a table for vendors and one for tenants and then I have a query that pulls the ones that are 30 days out from going overdue or that dont have a certificate of insurance into me yet (so I know whom I have to contact to get an updated copy). What I would love to be able to do is somehow have a way to auto send a generic email template to the email address for the tenants/vendors that are in the query warning them to get their updated certificate in immediately. Curious how to do that? If possible I would like it to actually take the attachment of the COI that I have on file (in the table that the query pulls from) and put that as an attachment in the email as well, so they have a reference copy to work off of.

Please help or let me know if any of this is even possible!

Thank you.

[Micron]

Are you still waiting or has this been answered elsewhere?
BTW - having attachments in an Access db is not advised. You don't say where the table is, so I'm making that assumption.

[June7]

There are many examples of VBA code to accomplish what you describe. Open recordset object in VBA, loop through the recordset, use SendObject method to send an email message to address in the recordset record.

Cannot use SendObject method to attach files to email. Requires code that opens and manipulates Outlook objects.
If you save COI in an attachment field in table, code would have to extract the file to external folder then attach that file to email.