Automate Email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I've read through several posting and several KB articles and haven't found
a quick or simple answer. I hope there is one.

I have used the docmd.sendobject to successfully send a report in Rich Text
Format via email This issue is the warning box that comes up "another
program is trying to send an email on your behalf". I don't want this to pop
up because I want this to run at night automatically and it will hang up the
program. Is there a simple way to bypass this?

Thanks
LeAnn
 
Sorry, I am using Access 2003 (in 2000 format) with Outlook 2003 in a
Microsoft Exchange environment.
 
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
 
Thank you for your response. I would like to use SendKeys to click the "YES"
button on the dialog box. The article that is referenced for send keys
doesn't seem to be appropriate for what I would like to do. I work in a
regulated environment and really son't want to (or can't) use a third party
tool. I would like to use the sendkeys statement in my procedure to "click"
on the YES button. I've tried different scenarios but the code is paused on
the security dialog. Is there a way to do this without WSH?

Here is what I tried:

'Send email notification of exceptions or failures
If lngRCnt <> lngICnt Then

DoCmd.SendObject acReport, strReport, "RichTextFormat(*.rtf)", "<my email
addy>", "", "", "Exception Report", "Open to view execptions",
False, ""

'I have also put a timer loop here but didn't make any difference

SendKeys "{TAB 2}" 'this executes only after I manually click
the YES btn
SendKeys "{Enter}"

End If
 
Back
Top