"new.microsoft.com" wrote in message ...
I tried to use the VBA code in Excel to send email automatically, but everytime the Outlook prompt up the warning message
"A program is trying to automatically send e-mail on your behalf" and waiting my confirmation. Is there is any ways to get rid of it?

Thanks



In outlook, Selct Tools Options Security. Uncheck the option called "Warn me when other applications try to send mail as me".

/Fredrik