Auto email a PDF report once per day

[theYaniac]

I have a macro set up to email a specific report from my database, I would like to automate it to send at 3am everyday. I have been unable to figure out how to set the time in the VBA code. Would love some assistance with this. Thank you in advance.

 

[welshgasman]

Is the DB open 24hrs?
If so look at the Timer event of the main form in the DB.

I'd probably use Task Scheduler to run a macro on opening

How to open access and run a macro in task scheduler

social.msdn.microsoft.com

HTH

 

[theYaniac]

the DB does not stay open.

 

[welshgasman]

Ok, so go with the Task Scheduler.
Create a batch/command file with contents something like

"C:\Program Files\Microsoft Office\Office12\msAccess.exe" "C:\Users\Paul\Documents\Test.accdb" /x mcrSendMSG

or directly in the scheduler.

Create a macro to run a Function that sends your report. Mine is mcrSendMSG

HTH

 

[theYaniac]

thank you