If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automating Report Emails
I have my MDB data stored on SQL server. I am wondering the what would be the
best method to have reports automatically run every morning at 6:00 AM and then email these reports to a distribution list. Do I use the windows scheduler to open a database that runs an autoexec macro that will run the reports, saving them to a file and then attach them to an email and send out? Can I attach more than one file to an automated email? Can I attach a .pdf file to the email? I would like to print a set of reports to a set of pdf files and email them as a bunch to a group of senior management. Is SQL server a better too to use? Can I ust DTS in SQL Server to open an access database and print reports to a file and then email them? If you have any suggestions on the best methof I would appreciate any advise. Thanks -- Jay |
Thread Tools | |
Display Modes | |
|
|