Send email to users automatically

  • Thread starter Thread starter Luke
  • Start date Start date
L

Luke

Auto-update is run every night that refreshes values in
several tables (Access 2000). If any of the updates is
not complete or fails to update the tables I need to send
an email message (Outlook) to selected users advising
them the data is incomplete. I have tried to use the
SendObject command:

strMessage = "<Message text>"

DoCmd.SendObject , , acFormatTXT, _
"<email address", , , _
"<Title>", strMessage, True

but get the same error message as described in Microsoft
Knowledge Base Article - 263084 and a personal
intervention is needed to send the message. Updating the
Outlook security is not possible now.

Is there another way to do this? Thank you for your
suggestions.

Luke
 
Hello Luke,

Questions regarding the Outlook Security prompt are asked very frequently.
The most complete answer has been provided by Outlook MVP Sue Mosher and is
quoted below. (Note: I have been very happy with the ClickYes utility
mentioned below and use the code provided at their web site to turn the
utility on and off.)

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

hth,
 
Hello Cheryl,

Thank you for the information. I will check it out and
let you know next week as I have an emergency I need to
deal with right now.

Thanks again.

Best regards,

Luke
-----Original Message-----
Hello Luke,

Questions regarding the Outlook Security prompt are asked very frequently.
The most complete answer has been provided by Outlook MVP Sue Mosher and is
quoted below. (Note: I have been very happy with the ClickYes utility
mentioned below and use the code provided at their web site to turn the
utility on and off.)

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
Click to expand...
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
Click to expand...
(http://www.dimastr.com/redemption/), a third-party
 
Hello Cheryl,

Thank you again for your suggestion from last week.

I have tried the ClickYes tool, but with no success. I
used the provided VBA code for Access, but I must be
doing something wrong since I have the same problems as
before, namely two pop up windows:
1. Profile Name (my sign on ID)
2. Website Data Update Error (informs me the message
has not been send; I have to click the Send button to
deliver the email).

So, I am back to square one. If you have any other
suggestions or ideas please let me know. I appreciate
your help.

Best regards,

Luke
 
Back
Top