Automated Emailing via Access

[Mohammed Zenuwah]

Hi There,

I'm hoping someone can help me. I run several reports daily from a Access
model connected to a sql data source. A lot of these reports are scheduled
a run via windows scheduler which has worked fine for over two years now.
I have just recently installed Office 2003 and all has been working fine
up until now. One of my processes to to email 15 reports to a distribution
list, via Outlook, previously this has never been a problem but today I'm
receiving a popup message for each report, alerting me to the fact a
program is trying to automatically send a mail and whether i would like to
continue this process, this feature is all very well but its making it
near impossible for me to automate this process, i now have to click 15
times before the reports are all sentout, not very automated...

I don't suppose anyone knows a way of turning this off? or perhaps an
addon feature for Access which can bypass outlook perhaps?

 

[Douglas J. Steele]

Questions regarding the Outlook Security prompt are asked very frequently.
The most complete answer has been provided by Outlook MVP Sue Mosher and is
as follows:

BEGIN QUOTED MATERIAL:

"The security dialogs that pop up when an application tries to access
certain Outlook properties and methods are designed to inhibit the spread of
viruses via Outlook; see
http://www.slipstick.com/outlook/esecup.htm#autosec. If you are a standalone
user, Outlook provides no way to suppress this behavior. However, you can
use a free tool called Express
ClickYes(http://www.express-soft.com/mailmate/clickyes.html) to click the
security dialog buttons automatically. Beware that this means if a virus
tries to send mail using Outlook or gain access to your address book, it
will succeed.

"If you're the administrator in an Exchange Server environment, you can
reduce the impact of the security prompts with administrative tools. See
http://www.slipstick.com/outlook/esecup/admin.htm

"If it's an application you wrote yourself, you can use one of these
approaches to redo the program:

-- Use Extended MAPI (see http://www.slipstick.com/dev/mapi.htm) and C++
or Delphi; this is the most secure method and the only one that Microsoft
recommendeds.

-- Use Redemption (http://www.dimastr.com/redemption/), a third-party
COM library that wraps around Extended MAPI but parallels the Outlook Object
Model

-- Use SendKeys to "click" the buttons on the security dialogs that your
application may trigger. See
http://www.slipstick.com/outlook/esecup.htm#autosec for a link to sample
code.

-- Program the free Express ClickYes
(http://www.express-soft.com/mailmate/clickyes.html) tool to start suspended
and turn it on only when your program needs to have the buttons clicked
automatically."

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm

END OF QUOTED MATERIAL

To learn more about using some of the alternatives Sue suggests, check out
the Access EMail FAQ Tony Toews has at
http://www.granite.ab.ca/access/email.htm