How schedule to run a report and email it to someone. 1

[qajussi]

Hi!

I have a monthly report query and would like to run it on the first day of each month for the previous month and email the report to my manager.

I have the access database and monthly report query(report).

Can you hint me in how to start this ?
Thanks.

 

[PHV]

Create a macro that do the mailing of the report (SendObject).
Then create a NT scheduled task lauching msaccess with the /x command line option.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mp9]

As an alternative to creating a scheduled task, check out the freeware Handy Access Launcher (HAL) at

http://www22.brinkster.com/accessory/resources/001.shtml

(you'll still need to create the macro first though).

http://www22.brinkster.com/accessory/

 

[mp9]

As an alternative to creating a scheduled task, check out the freeware Handy Access Launcher (HAL) at

http://www22.brinkster.com/accessory/resources/001.shtml

(you'll still need to create the macro first though).