Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Macros / March 2006

Tip: Looking for answers? Try searching our database.

SendObj macro and Outlook... annoying pop-up message help!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RobertR - 31 Mar 2006 00:29 GMT
Hey everyone.

I've recently set up a SendObj macro to e-mail personal reports to
management members in one fell swoop.  The macro consists of about 25 SendObj
calls, each sending a different report to a different e-mail.  My problem is
this:

Everytime I start the Macro up, I get a message from Outlook that reads "A
program is trying to automatically send e-mail on your behalf.  Do you want
to allow this?  If this is unexpected, it may be a virus and you should
choose No.".  This appears before each and every e-mail to be sent out, and
each has a 5-second delay before you can click on "Yes".  In short, amazingly
annoying when I'm trying to speed these reports out to people.

Does anyone know how to bypass this, or how to get Outlook to recognize this
as an acceptable action?  Thanks!
Douglas J. Steele - 31 Mar 2006 00:44 GMT
Questions regarding the Outlook Security prompt are asked very frequently.
The most complete answer I've seen was 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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hey everyone.
>
[quoted text clipped - 18 lines]
> this
> as an acceptable action?  Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.