Schedule MS Access report to be sent out as PDF documents through MS Outlook

[phaniakella]

Dear Experts

I have a report in MS Access. It needs to be converted to pdf and sent to a list of people as mail through MS Outlook at 12:00 Noon on Monday and Thursday. Please let me know how can i achieve this. I don't have much knowledge regarding macro programming. Please help me with relevant links.

Thanks
Phani

 

[pbaldy]

As mentioned elsewhere:

Personally I'd probably create a db that sent out your emails when it opened, then closed itself. Then I'd call that db from Windows Scheduled Tasks on the desired schedule. A macro named autoexec will run when the db opens, and can either do your process itself or call a function that does it (my preference).