When your VBA script attempts to send email from Outlook you may get a security warning "A program is trying to automatically send emails on you behalf. Do you want to allow this?".
One way to switch off these warning is to have a valid antivirus program installed. If you have an antivirus that Outlook recognizes thne you will see the below message when you go to Tools\Trust Centre\ Programmatic Access (in the left column) in Outlook:
"Antivirus status: Valid"
If Outlook doesn't recognise the antivirus program, which can happen sometimes even if you have one installed, you will see the message:
Antivirus status: Invalid, This version of Windows supports antivirus detection, but no antivirus was found."
I get this happening sometimes at my work were I have MacAfee installed but Outlook doesn't recognize it from time to time.
One way to switch the warning off is to click the "Never warn me about suspicious activity (not recommended) in the Programmatic Access setting of Outlook.
[img]http://fracta.net/fracta/images/Outlook Programatic Access.GIF[/img]
Hope this helps.
