Send E-Mail

  • Thread starter Thread starter Chris C.
  • Start date Start date
C

Chris C.

Hi,

I am creating a little MS Access "daemon" to check for e-mail notificatoins
it needs to send based on users' entered data. When it finds qualifying
rows, it's supposed to shoot off an e-mail via a docmd.sendobject, which is
working fine.

My problem is that at my institution we default to MS Outlook, and there's a
little security check in our install which prompts something to the tune of
"a program is trying to send an e-mail on your behalf. Do you want to do
this?", prompting for a Yes/No selection. Clearly, if I'm to automate these
e-mails, I am not going to watch for and answer these dialog boxes 24/7.

How can I avoid this? My institution isn't going to back off this rule.
Can I instruct VB to use another client, e.g., OE? How do I do this? Are
there other, even simpler e-mail methods that don't need to tap into a
workstation clients?

Chris
 
Chris,

What you are seeing is the Outlook Security Prompt, which is designed to
inhibit the proliferation of email viruses. You'll see this prompt if you
use Visual Basic. Not sure about OE, as I do not use it as an emailer.

If you are working in an Exchange Server environment, there is a
toolkit/patch available to control the appearance of the Outlook Security
Prompt:

http://www.slipstick.com/outlook/esecup/admin.htm

Otherwise, you'll find an extensive review of all of the options available
to work around the Outlook Security Prompt at:

http://www.slipstick.com/outlook/esecup.htm#autosec

The easiest work-around that I have found is to install the free ClickYes
utility found at:

http://www.express-soft.com/mailmate/clickyes.html

This utility can be incorporated into VBA code and will automatically click
the 'Yes' button of the security prompt. The writers of this software have
included code at their website which shows you how to turn the Utility on
and off from within your code. I have used this in more than one client
application and the most frequent problem I've seen is convincing users to
"keep their hands off the mouse".

hth,
 
Back
Top