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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Use windows scheduling to open the database at the appropriate time and run
the macro.
 
Back
Top