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?

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" wrote:

> 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 wrote:
> >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?
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...urity/200810/1
>
>

Trust Center Window

Macro Security Options

Check No warning and diable all macros.



"thefonz37" wrote:

> 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

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.

"Chris O'C via AccessMonster.com" wrote:

> 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
>
>
> thefonz37 wrote:
> >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.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...urity/200810/1
>
>

On Wed, 10 Dec 2008 14:48:03 -0800, thefonz37 wrote:

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

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

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

"Rick Brandt" wrote:

> On Wed, 10 Dec 2008 14:48:03 -0800, thefonz37 wrote:
>
> > 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.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>

On Wed, 10 Dec 2008 18:53:00 -0800, thefonz37 wrote:

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

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

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

"Rick Brandt" wrote:

> On Wed, 10 Dec 2008 18:53:00 -0800, thefonz37 wrote:
>
> > 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.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>