Disabling e-mail security in Access

[JMH022]

I have built a database that e-mails various reports based on selections made on a form by the user:

If Forms!frm_Reporting1!optREPORT1.Value <> 0 Then
DoCmd.SendObject acReport, "rpt_REPORT1", _
"RichTextFormat(*.rtf)", email@email.com, "", "", Date & _
" Report", _
"Attached is the current Report.", False, ""
End If

I am using Office 2002 and keep getting a warning box from Outlook:

"A program is trying to automatically send e-mailon your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No"."


Does anyone know how to disable this warning so it doesn't pop up every time I send the report? There are some days I am sending 45 separate reports and this pops up before every one of them.

 

[Cbrine]

JMH,
I believe that this is possible, although I've never done it. I've heard from a few programmer's that Extended MAPI can bypass this message. You might want to check the MSDN site.

HTH
Cal

 

[Andrew Fergus]

Hi, following on from Cal, the following quote

"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

came from this forum

I haven't tried it myself but HTH, Andrew,

 

[JMH022]

Cal/Andrew:

Thank you very much! You saved me!