Automating a report to be sent at a specific time during the day

[Guest]

Is there a way to automate sending a report at a specific time during the
day? I created the macro to send out the email but how do I tell it what
time to do it. I do not want to run it each day.

Thanks,
Tricia

 

[Rick B]

If your database is open, you could add a timer event tot ahidden form that
would fire it. The timer would compare the current time to a set time and
then fire the event.

The form would have to be open (could be in hidden mode) for this to work.

Rick B

 

[Mark Andrews]

Use windows scheduling to open the database at the appropriate time and run
the macro.