Brad Marks
brad.marks1 at gmail.com
Wed Jun 9 20:59:16 CDT 2010
We would like to run a number of Access 2007 reports at night and then e-mail them to select managers. Using the Windows scheduler, we can initiate Access, run the reports, and store them as PDF files. This all works nicely. We keep running into obstacles with every approach that we have tried to automate the e-mailing of these reports in an unattended environment (Terminal Services / Remote Desktop). We would prefer to use Outlook, but we are open to other approaches. We are curious how others handle this situation. Thanks, Brad