[AccessD] How to send Automated E-mails from Access after hours

Brad,

I use http://www.chilkatsoft.com/Email-ActiveX.asp and have found it great - 
easy to use and works without a hitch.  Not free.

Regards
Steve


--------------------------------------------------
From: "Brad Marks" <brad.marks1 at gmail.com>
Sent: Thursday, June 10, 2010 1:59 PM
To: <accessd at databaseadvisors.com>
Subject: [AccessD] How to send Automated E-mails from Access after hours

> 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.