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

Had the same requirement in a legacy app that was using an SMTP approach an
CDO.  But it stopped working - don't really know why - obsolete technology?
Client is using Exchange - don't know that that's relevant.  

Anyway, I have implemented vbSendMail and it seems to work pretty smoothly.
I got turned on to it by the list.  You can probably find the thread in the
archives.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Wednesday, June 09, 2010 6: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.

Thanks,
Brad
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com