Dan Waters
df.waters at comcast.net
Thu Jun 10 11:21:18 CDT 2010
Brad, When you set up the scheduled task, be sure that you uncheck 'Run Only When Logged On'. You also need to be sure that the person's name/password you enter must have authority to work on the PC/Server where Access will be running. By doing these two things the scheduled task will run unattended, and will have the authority to initiate the task. Good Luck! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Thursday, June 10, 2010 10:22 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] How to send Automated E-mails from Access after hours From what Brad said, I think not as he said it runs fine while logged in. As for the dialog, that depends if you digitally signed your project or not and what your current macro settings are (sandbox mode). How it works and what it affects is confusing at best. I don't get into any type of installs (I don't sell any type of a commercial product) so I always have my users simply set their macro security to low in Access, and everything runs without any of the security dialogs. I'm not sure what could be going wrong with a Wise/SageKey install. I would say though at a minimum, the VBA project should be self-signed. Which I suppose at some point, I'll probably have to start doing myself, install or not. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Thursday, June 10, 2010 10:03 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] How to send Automated E-mails from Access after hours 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 -- 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