Problem: 'pop up' when VBA tries to send automated email via OUTLOOK

[VbPanicStation]

I have written a program in VBA ACCESS which is meant to send out automated emails via outlook. The problem is that when ever I run the program, a pop up is displayed which reads 'A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose 'No'. Yes, No & Help options are given.

How can I disable this 'pop up' from within the VBA program? As different users are going to use the program, I can not rely on them to press yes.

 

[xlbo]

see these FAQs
faq707-5230
faq707-1904

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Karja]

I've met this same problem. Of course it is a protection against spam. If I am correct it is a server setting which not everybody is happy to change.

Perhaps the following program helps you further:

http://www.miesoftware.com/Support/Articles/ols61.htm

 

[VbPanicStation]

?

 

[xlbo]

? what ?

what do you not understand

we are not mind readers

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[jrbarnett]

There's another recent discussion of this very problem in thread705-1254235.

John

 

[fumei]

Actually that "recent" discussion was on a thread posted by this same poster...with the very same question.

Gerry
My paintings and sculpture