Scheduling automatic Email of Reports

[Will]

What's the best way to get Access to automatically email out reports to
different users at a particularly time of the day? The application is not
always open 24/7. I have searched but can't find much.

Thanks in advance

 

[Rick B]

If the application is not open, then you can't do it in Access. There may
be some thrid-party option. If you can force Access to open, then you could
have code in the startup that woud do it.

 

[Baz]

What's the best way to get Access to automatically email out reports to
different users at a particularly time of the day? The application is not
always open 24/7. I have searched but can't find much.

Thanks in advance

If Access isn't running then it can't do anything, so the first thing you
will need to do is to use the Windows scheduler to launch Access. In the
command line that launches Access, you will need to use the /cmd option to
pass in an argument indicating that you are in "automatic email" mode, and
in your startup form you will need to use the Command() function to detect
the argument and then run your report-emailing code.