Automatically send weekly report PDF via email

[BadBoy House]

We have an Access database with various forms, reports etc.

I would like an email to be sent out automatically each week which contains a PDF version of a report as an attachment.

It would need to run automatically according to a schedule rather than requiring input from a user.

We use Office 365 for our email system so I imagine it would also need some way of logging in to the email account automatically in order to send the email.

Is this something that can be done with Access 2016?

 

[pbaldy]

You can test using SendObject and see if it successfully sends out your report. Presuming so, I'd create a version of your app that just contains the relevant parts. Create a function that sends out the report and then quits the app. Call that function from an autoexec macro, then call the app from Windows Scheduled tasks.