Run command on a specific date

  • Thread starter Nicholas Scarpinato
  • Start date
N

Nicholas Scarpinato

Hi. I have a database that gathers data for return tags for customers who are
returning their rented instruments to the store. At the end of each week I
have to email the list of tags for that week to the store manager. Is there a
way to set up Access to automatically run my email macro every Friday?
 
G

Gary Watson

You could try starting a scheduled job to run Access, using the command line
option /X <macro> to run a macro.

Gary
 
N

Nicholas Scarpinato

I knew about that, but I have to run the database on a daily basis anyway,
and I have to run a report from our retail system first before I can run the
database. Some days I run the report at 9am, other days I don't get to it til
3pm... so having the database run at a set time is a no go.
 
Top