Disable E-Mail Warning

[thefonz37]

I'm writing a database that sends e-mail notifications to employees once
their vacation requests are approved. However, I'm having a problem with the
window that appears for each e-mail message I try to send.

The window reads: "A program is trying to send an e-mail message on your
behalf. if this is unexpected, click Deny and verify your antivirus software
is up-to-date.

For more information about e-mail safety and how you might be able to avoid
getting this warning. click Help."

Then there is a status bar and the options, "Allow", "Deny", "Help".
Clicking help takes you to the table of contents for the help file and offers
no specific information for how to disable this.

The problem is that receiving 10-20 requests a day, it's very time-consuming
and troublesome to wait for the status bar 10-20 times and have to click
"Allow" for each notification. Can this be disabled?

 

[Chris O'C via AccessMonster.com]

If the mailbox is on the Exchange server it can be disabled by a setting on
that server. If the mailbox is on the user's pc and the mail client is
Outlook 2000 to 2003, download Click-Yes. It's free unless you want the pro
version, which is required for Outlook 2007.

http://www.contextmagic.com/express-clickyes

Chris
Microsoft MVP

 

[thefonz37]

It is Outlook 2007, unfortunately.

I'm kind of disappointed with Microsoft on this one - I can't believe I have
to talk to our e-mail server administrator to get rid of this inconvenience.

Thanks for the suggestions anyhow!

 

[Chris O'C via AccessMonster.com]

Microsoft did it for security reasons, but I think mainly because so many
spammers have compromised pcs that don't have any other security. It cuts
down a lot of spam when the user gets the notifications, like hundreds in a
row. Even the most "I don't know anything about computers" user will think
something is up or at least broken and refuse to send the emails. Probably
just turn off the pc because they can't do any work on the pc between
authorizing all those suspicious email messages going out.

Chris
Microsoft MVP

 

[Paul M]

Trust Center Window

Macro Security Options

Check No warning and diable all macros.

I'm writing a database that sends e-mail notifications to employees once
their vacation requests are approved. However, I'm having a problem with the
window that appears for each e-mail message I try to send.

The window reads: "A program is trying to send an e-mail message on your
behalf. if this is unexpected, click Deny and verify your antivirus software
is up-to-date.

For more information about e-mail safety and how you might be able to avoid
getting this warning. click Help."

Then there is a status bar and the options, "Allow", "Deny", "Help".
Clicking help takes you to the table of contents for the help file and offers
no specific information for how to disable this.

The problem is that receiving 10-20 requests a day, it's very time-consuming
and troublesome to wait for the status bar 10-20 times and have to click
"Allow" for each notification. Can this be disabled?

diable the

 

[thefonz37]

Hehe, true. The problem is, though, that I'm the clueless end-user in the
case who is being annoyed to death by the pop-ups. I know very well that the
database I developed isn't sending illicit e-mails out and it's just one
life's annoyances that I will just have to live with I guess.

Oh well.

 

[Rick Brandt]

Hehe, true. The problem is, though, that I'm the clueless end-user in
the case who is being annoyed to death by the pop-ups. I know very well
that the database I developed isn't sending illicit e-mails out and it's
just one life's annoyances that I will just have to live with I guess.

Oh well.

It's not very difficult to use code to automate the CDOSys messaging
library (inlcuded in Win2000 and newer). That doesn't generate the
security message.

 

[thefonz37]

Ok, tell me more using language like I've never heard of what you mean before
(because I haven't

 

[Rick Brandt]

Ok, tell me more using language like I've never heard of what you mean
before (because I haven't

If you read these groups much you will see people talking about using
code to manipulate Word, Excel, Outlook, etc.. VBA can use COM to
utilize code that is actually contained in external libraries that have
nothing to do with Access or even Office.

One thing that can be done with this is to utilize the CDOSys.DLL that is
on Windows machines. This is a messaging library that can (among other
things) send Email messages.

I can't provide a code example at the moment, but if you search the web
for "CDOSys VBA code examples" you should be able to find examples that
with just a little tweaking can be dropped right into your project.

As with most such things, the code might look a little intimidating if
you are not too experienced, but making the code function in your app
doesn't require that you understand all of it. You normally end up with a
fairly straight-forward function or class that is pretty simple to send
messages with. You can even include attachments (as many as you like)
and create formatted HTML messages if desired. I haven't used SendObject
in years.

 

[thefonz37]

Fantastic, I'll research it. Thanks for your advice.

 

[Chris O'C via AccessMonster.com]

You don't have to live with it. Identify which app is sending email from
your pc. If it's legit, let it stay. Find a way to send the email without
prompts. Otherwise it's malware and it gets the boot.

Chris
Microsoft MVP

Hehe, true. The problem is, though, that I'm the clueless end-user in the
case who is being annoyed to death by the pop-ups. I know very well that the
database I developed isn't sending illicit e-mails out and it's just one
life's annoyances that I will just have to live with I guess.

Oh well.

Microsoft did it for security reasons, but I think mainly because so many
spammers have compromised pcs that don't have any other security. It cuts

[quoted text clipped - 11 lines]