Link to home
Start Free TrialLog in
Avatar of rosemary fletcher
rosemary fletcher

asked on

Access Database 2007 - automating reports being sent by email

We have an Access Database which generates two reports and we would like to have the system automatically issue these reports ever Monday.     Can this be accomplished in Access?
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Rosemary,

 The best way to accomplish this is to use the Windows Task scheduler to open an Access app.  Then you can use one of the methods here:

https://www.experts-exchange.com/videos/537/MS-Access-Different-Ways-to-Start-Up-a-Database.html

 To start it up and get it to execute the report.

Jim.
ASKER CERTIFIED SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial