Run a Macro on every Friday

[yfzowner]

First off, hello everyone I am new here.

I need to create a Macro that will send a snapshot of a report in someone's e-mail every Friday morning. I have already created the macro that sends the report, I just am having a tough time figuring out what kind of syntax is required to run it every friday. Can anyone help me please?

Thank you

 

[yfzowner]

Perhaps I worded it wrong

Maybe there is some confusion.... I created a macro that sends a snapshot of a report to someone's e-mail address. What I need to do now is automate it to send on a specific day of the week. I don't know if it easier to do within the macro, or if I need to use Visual Basic. Regardless, I am having a tough time creating the code that will allow this to run correctly. I am new to using Access, I was instructed on how to use SQL when I was in college and haven't had to use any of that code knowlege until now, so most has been forgotten.

 

[WayneRyan]

y,

You can use the Windows Task Scheduler to run your database at the
desired time. The command line that starts Access can execute your
macro, or you can use the AutoExec macro.

You can alternatively right-click on your report (on the database tab)
and create a shortcut to run the report. One of the report's events
could be used to run your macro.

Wayne

 

[yfzowner]

Awesome, I didn't even think of that. How easy. Thank you.

 

[yfzowner]

Any idea of how to make it not prompt me about letting it send?

 

[tyront]

i'm not exactly an expert but i believe you could try having a hidden table field with the first friday you want to run it's date as a value. then set a condition datefield+7. then in the same macro have a setvalue action to set the value to date() under the same condition

hope this helps
tyront

 

[atisz]

Question

y,

The command line that starts Access can execute your
macro

Wayne

How you do that?