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

Brad Marks BradM at blackforestltd.com
Wed Jun 9 22:25:45 CDT 2010


Bill,

Thanks for the advice.

I will look into this method.

Brad


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Bill Benson (vbacreations)
Sent: Wed 6/9/2010 9:31 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How to send Automated E-mails from Access after hours
 
The best approach I know is CDO and a SMTP e-mail server. I have even
written code to send e-mails via YAHOO and GOOGLE, if you don't have a ready
SMTP server.

There are numerous examples of code out on the internet, here is a sample.

I suggest Googling 
	cdo vba email attachments

 ... best way to get good code and samples applicable to VBA.
Example:  http://www.rondebruin.nl/cdo.htm




-----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
No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 9.0.829 / Virus Database: 271.1.1/2927 - Release Date: 06/09/10
02:35:00


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

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.




More information about the AccessD mailing list