Rocky Smolin
rockysmolin at bchacc.com
Thu Jun 10 09:03:02 CDT 2010
Jim: Creating a run time (Wise/Sagekey) of an app that uses vbSendMail I got the 'no digital signature' message. I'm wondering if that might be the offending element. I switched to vbSendMail after the legacy code (SMPT/CDO) started to fail. Could that be because the environment changed? TIA Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Thursday, June 10, 2010 6:36 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] How to send Automated E-mails from Access after hours 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com