Forum Discussion
Automate Sending Reports from Access
Is there a way to automate report generation in Access on a scheduled basis and send them externally for viewing on a phone for mobile use since access is PC only based?
Export the report as a PDF and email it so it can be viewed on a mobile phone as an attachment.
Create a macro to do the whole process automatically i.e. run the report, save as PDF & then create the email e.g. using CDO
You can then use Windows Task Scheduler to open Access using the /macro switch at specified times/dates
Create a macro to do the whole process automatically i.e. run the report, save as PDF & then create the email e.g. using CDO
You can then use Windows Task Scheduler to open Access using the /macro switch at specified times/dates