Bill Benson (vbacreations)
vbacreations at gmail.com
Wed Jun 9 21:31:34 CDT 2010
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