Access sending outlook emails (1 Viewer)

Hi all,

I have many records that have a pc number and a audit date and when it was last audited. I want when the db opens to run a email send script to send a list of machines that are overdue to 1 month.

The email will be like the following example.

Subject= Manual Audit overdue Reminder
Body= the following machines audits are overdue.

pc1
pc2
pc3
pc4

Many thanks
James

make a report to show the data, then:

docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo,,,sSubj,sBody

There's a bit more meat for you to chew on in this article:

https://msdn.microsoft.com/en-us/vba/access-vba/articles/docmd-sendobject-method-access