Access/Outlook Question

  • Thread starter Thread starter Michelle Musal
  • Start date Start date
M

Michelle Musal

I have a user with an Access database that has a
switchboard startup form. One of the buttons automatically
sends three reports to a group of users via email. When
this database was created we were using Office 2000 on a
Windows 2000 operating system. We recently upgraded
hardware and our operating system to Windows XP; however
we still use Office 2000. Since the upgrade the user gets
an authorization pop-up for each report for each user in
the Access distribution list. I have reset the Outlook
security level, but the pop-ups are still appearing
everytime we use the Access Macro button. Does anyone have
any idea how I can make the reports just send without
asking permission. FYI: if I run the macro on the old
computer with Windows 2000, it works without the pop-ups.
 
Michelle,

When you upgraded, you also upgraded Outlook security. These prompts are
designed to diminish or prevent the proliferation of email viruses. The
most complete answer on what to do 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. [NOTE from Cheryl: I use Express ClickYes and the code it
provides at its website to turn on the utility just before the emails are
constructed and sent and to turn it off after the email process is
completed.]

"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
 
Back
Top