Scheduling Macro to run automatically

[KittyKool]

Hi.

I'd like to email a report from Access on a weekly basis aithout having to
go into the database and run the macro. Is there a way to get the macro to
automatically run once a week?

Thanks in advance!

 

[Steve Schapel]

Kitty,

You can use Windows Task Scheduler, or some other scheduling software,
to make this happen. The Command Line in the scheduled task will look
something like:
"C:\Program Files\<PathToAccess>\Msaccess.exe"
"C:\YourFolder\YourDB.mdb" /x NameOfMacro

 

[KittyKool]

Thanks Steve. Unfortunately I don't have that Software. Is there any other way?

 

[Douglas J. Steele]

You sure? Go into the Control Panel and look for an applet with a name like
Scheduled Tasks.

 

[GeorgeR]

Is there a trick to getting these to run when you are not logged on to the
computer. Mine runs, but I have a feeling it is getting caught by a macro
security pop up that I was able to turn off in my profile?