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?

 

[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!

 

[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.