Automatic report email timer

[RevJeff]

Hello all!

I am trying to have access email a report to a group of people every 15 minutes. Between 10a and 4p. This is not a daily thing. It will only be needed 2 or 3 times a year. I could use windows scheduler but if possible, I would rather have just have the database open on an computer and have it send the report automatically.

I am capable of creating the report and sending the email to the required people. I just need some guidance on creating the code to generate the report on a 15 minute timer. If possible.

Thanks for any help

 

[CJ_London]

in a form load event set the form timerinterval to 900000 (1000=1sec * 60secs *15mins)

in the form timer event, put the call to your function/sub to send the emails - something like

if time >=#10:00:00# and time<=#16:00:00# then sendemails

 

[RevJeff]

Thank you for your help!