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

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




More information about the AccessD mailing list