I am using the Access macro EMailDatabaseobject to create a PDF report that is emailed to X recipient. However, when I run the macro it simply opens and Outlook send email message with the PDF attached.
Which is nice, however, what I want to do is automatically send this email. I am setting up scheduled tasks to run these reports say once a week and they need to run when I am not around.
Everything I find is older vb scripts to automatically fill in lists of customers. I simply need to send it to X department heads on Y schedule.
The script I use to run it is as follows:
"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.E
XE" /ro c:\RoutineReports\sp_repor
ts.accdb /x EmailFutureEvents /nostartup