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

Jim Dettman jimdettman at verizon.net
Thu Jun 10 08:36:12 CDT 2010


Brad, 

 What you need is software that talks directly to a SMTP server.  You can
but a 3rd party control or use something like BLAT or vbSendMail (both
free).

 I would not be using Outlook with OLE and even CDO, both which depend in
large part on the environment they run under.

 Talking directly to a SMTP server is very low level (not difficult though)
and there is not a lot to get in the way.

 As far as running, you code cannot output anything to the screen if it's
going to run un-attended from task scheduler.

Jim.

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




More information about the AccessD mailing list