Timed Event ?

[Greg]

Is there a way to send a report at a given time every week.

I have a work log that I would like to send by email to the corperate office
automatically
each week... Like Thursday at 12:00am. If not how about a timer that will
remind users to click the send button.

Can this be done?

 

[John Vinson]

Is there a way to send a report at a given time every week.

I have a work log that I would like to send by email to the corperate office
automatically
each week... Like Thursday at 12:00am. If not how about a timer that will
remind users to click the send button.

Can this be done?

I'd use Windows Scheduler. It can be set to launch a database at a
specific time; you can use the /x macroname switch to have it open the
database and execute a specific macro (which can call your VBA
function to launch the report and email it).

John W. Vinson[MVP]