Send Automated email at specific time

[Guest]

Is is possible in access to send a report at specific time? I have a report
that I would like to send every day at 7 am

 

[John W. Vinson]

Is is possible in access to send a report at specific time? I have a report
that I would like to send every day at 7 am

You can use Windows Scheduler to launch Access at a specific time. This is one
case where macros are handy, because you can launch a specific macro in the
command line:

"%programfiles%/Microsoft Office/Office11/msaccess.exe"
"D:/somepath/mydatabase.mdb" /excl /x RunMyReport

will run the macro named RunMyReport. It will need to open the report, call
whatever code you have to send the email, and Quit the database.

John W. Vinson [MVP]

 

[Guest]

Hi Geg

To follow on from John's answer - have a look at this post I made a while
ago regarding using scheduler. If you are not used to using scheduler then
this will give a step by step method

http://groups.google.com/group/micr...c/0ad542bc771f5144?lnk=st&q=#0ad542bc771f5144


--
Wayne
Manchester, England.

 

[Guest]

Make a macro to do it, then drag that macro from access to a folder in
windows explorer. Then use windows scheduler to schedule running that macro
( not the access file itself ).

 

[John W. Vinson]

Hi Geg

To follow on from John's answer - have a look at this post I made a while
ago regarding using scheduler. If you are not used to using scheduler then
this will give a step by step method

http://groups.google.com/group/micr...c/0ad542bc771f5144?lnk=st&q=#0ad542bc771f5144

Thanks Wayne! That's got some goodies I hadn't seen. Would you be interested
in posting it on a perhaps more secure site such as www.mvps.org/access or the
Utter Access code library?


John W. Vinson [MVP]