Access & Outlook

[Guest]

We have some VBA code that generates and automatically sends emails..the code
looks like...

Dim mobjoutlook, mobjcurrentmessage
Set mobjoutlook = CreateObject("Outlook.application")
email_form = email_form_name
Set mobjcurrentmessage = mobjoutlook.Createitemfromtemplate(email_form)
send_to = customer.HyperlinkAddress
mobjcurrentmessage.Recipients.Add (send_to)
mobjcurrentmessage.send

it works great, however...when it executes the .send, we get a warning from
Outlook that another program is attempting to access Outlook and we have to
allow the access for 1 minute to 10 minutes. My question is...is there a way
to eliminate this warning? I've tried docmd.setwarnings false before the
..send and docmd.setwarnings true right after the send, but the message
persists.

Please help...we need to send emails to many people, (100+) at a time and
it's not feasible to have someone sit there answering the same question over
and over.

Thanks in advance for your help!

 

[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

 

[Guest]

Hi Peter,

In addition to the information quoted by Doug, there are two other options
that you might find acceptable:

1.) Fairlogic WorldCast (free for non-commercial use)
http://www.fairlogic.com/worldcast/index.shtml

2.) Total Access Emailer by FMS (not free)
http://www.fmsinc.com/products/Emailer/index.asp


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

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


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)
__________________________________________

:

We have some VBA code that generates and automatically sends emails..the code
looks like...

Dim mobjoutlook, mobjcurrentmessage
Set mobjoutlook = CreateObject("Outlook.application")
email_form = email_form_name
Set mobjcurrentmessage = mobjoutlook.Createitemfromtemplate(email_form)
send_to = customer.HyperlinkAddress
mobjcurrentmessage.Recipients.Add (send_to)
mobjcurrentmessage.send

it works great, however...when it executes the .send, we get a warning from
Outlook that another program is attempting to access Outlook and we have to
allow the access for 1 minute to 10 minutes. My question is...is there a way
to eliminate this warning? I've tried docmd.setwarnings false before the
..send and docmd.setwarnings true right after the send, but the message
persists.

Please help...we need to send emails to many people, (100+) at a time and
it's not feasible to have someone sit there answering the same question over
and over.

Thanks in advance for your help!