SENDING REPORT VIA E-MAIL 1

[chubby]

How can I setup my access database to send a report via e-mail automatically every Wednesday or whatever date I choose to send my report to the Department Heads.

I want this report to be sent out without me pushing any buttons (auto)....
ThanX..

 

[JoeMiller]

The easiest way is to make a macro that when run sends the report via email to your boss. Then you can open access from the command line and call the macro from your shortcut. Then place this shortcut into task scheduler and set it to run the task on whatever schedule you need it to. Here's an example of the macro calling commandline:

"C:\Program Files\Microsoft Office\Office\MSAccess.exe" "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb" /x MyMacroName Joe Miller
joe.miller@flotech.net

 

[chubby]

Thanks Joe, your still the best!!!