Scheduling Macro to run automatically

  • Thread starter Thread starter KittyKool
  • Start date Start date
K

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!
 
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
 
You sure? Go into the Control Panel and look for an applet with a name like
Scheduled Tasks.
 
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?
 
Back
Top