hi,

i am trying to send an automatic mail from excel VBA to the outlook
outbox,

when i send i obtain this error

A progam is trying to automatically send e-mail on your behalf.


the help buttom says:

A program is trying to send mail using Item.Send
A program is trying to automatically send e-mail using a Microsoft
Outlook Visual Basic Application command, Item.Send. If you want this
program to send this e-mail, click Yes. To stop the program, click No.
If you are unsure which program is sending the e-mail or why, you may
want to click No to avoid any possible spread of viruses.

Note When this message is displayed, the Yes button is not available
for 5 seconds.

how can i disable this protection?

tks in advance

"rhXX" wrote in message
ups.com...
i am trying to send an automatic mail from excel VBA to the outlook
outbox,

when i send i obtain this error

A progam is trying to automatically send e-mail on your behalf.


the help buttom says:

A program is trying to send mail using Item.Send
A program is trying to automatically send e-mail using a Microsoft
Outlook Visual Basic Application command, Item.Send. If you want this
program to send this e-mail, click Yes. To stop the program, click No.
If you are unsure which program is sending the e-mail or why, you may
want to click No to avoid any possible spread of viruses.

Note When this message is displayed, the Yes button is not available
for 5 seconds.

how can i disable this protection?

Well, if you could do it, so could all the virus writers.

That said, if you're running 2k7, you can suppress many of these messages,
tho, iirc, it'll be all or nothing, so if there's some Excel VBA virus out
there that does a item.send, it'd be supressed there too.

--
f.h.

See outlookcode.com for possible methods to work around this problem.

http://www.outlookcode.com/article.aspx?ID=52 - part way down the article
are links to outlook 2007 specifics.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"rhXX" wrote in message
ups.com...
hi,

i am trying to send an automatic mail from excel VBA to the outlook
outbox,

when i send i obtain this error

A progam is trying to automatically send e-mail on your behalf.


the help buttom says:

A program is trying to send mail using Item.Send
A program is trying to automatically send e-mail using a Microsoft
Outlook Visual Basic Application command, Item.Send. If you want this
program to send this e-mail, click Yes. To stop the program, click No.
If you are unsure which program is sending the e-mail or why, you may
want to click No to avoid any possible spread of viruses.

Note When this message is displayed, the Yes button is not available
for 5 seconds.

how can i disable this protection?

tks in advance

On Jun 17, 12:23 am, "Diane Poremsky" wrote:
See outlookcode.com for possible methods to work around this problem.

http://www.outlookcode.com/article.aspx?ID=52- part way down the article
are links to outlook 2007 specifics.


ok, tks to all!

a simple method to avoid virus: a security barrer to all (virus and
not virus) ...

i think a selective method would be done, ie, password or chipered
access.