Hi,

I have created a macro that sends a database report to an email.

Is there any way to "tell" Access to automatically run this macro, say, every Monday?

filo

Is the database always running? If so, you would need to create code to run, probably in the timer event at least once a day to see if it is Monday, then run code to fire the macro (macros are bad - change that to vb :-B).

If the db is not always on, the create a Windows Scheduled task to fire up the database every Monday, and then set an autoexec macro to run the codd in question.

HTH :rolleyes:

Thanks for your reply.

The db is not always on, so the second suggested solutions is the one that fits my needs best.

Now, how do I do all that???? :confused:

filo77