rhXX


hi,

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

when i send the mail i obtain this security warning:

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

may i use SendKeys to "press OK" after 5 seconds how can i do it

tks in advance





Re: VBA excel outlook / A program is trying to send mail using Item.Send

rhXX

cath, tks a lot!

i bypassed the problem launching a vbscript just before to send the mail, which waits for the warning windows, waits 5 seconds, and "press" left + enter. i took the idea from the article

http://www.itoc.usma.edu/Workshop/2001/Authors/Submitted_Abstracts/paperT1B1(24).pdf

tks for ur help!





Re: VBA excel outlook / A program is trying to send mail using Item.Send

hp4fueltek

HI rhXX

I am facing similar problem as u did. Could you please give me some details how did u manage to bypass outlook security message.

thankz





Re: VBA excel outlook / A program is trying to send mail using Item.Send

rhXX

hi hp4,

i did resolve the problem. now i am leaving for a month, so i can not extend now.

pse see http://softwareetal.blogspot.com/2007/06/outlook-security-error-program-is.html where is how i resolved it.

regards




Re: VBA excel outlook / A program is trying to send mail using Item.Send

Jon Peltier

You could also try using CDO:

http://www.rondebruin.nl/cdo.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______





Re: VBA excel outlook / A program is trying to send mail using Item.Send

Shasur

Here is the one that worked for me

http://vbadud.blogspot.com/2007/04/vba-email-automation-vba-mail.html

Cheers

Shasur






Re: VBA excel outlook / A program is trying to send mail using Item.Send

LuisEG

I tried the Wscript but for getConfig, it shows an "Function not defiened" error message. Is it part of another pice of code or just default to WScript

Thank you,