I’m having a problem when sending my reports with the sample script listed in here Send Mail via VBA
Some warning always popup whenever the script tries to send email.
"A program is trying access e-mail addresses you have stored in Outlook. Do you want to allow this? If this is unexpected, it may be a virus and you should choose “No”. "
I tried searching the forum and found out some suggestion about blat. Not sure what it is though.
My script is quite similar to the ones you’re referring, using CDO. However it still doesn’t solve my problem which is causing an outlook warning to popup everytime the script runs.
The script does the job just fine, but I still need to click the confirmation button on the popup, which eliminate the purpose of the script altogether, which is to automate the report delivery via email.
I’m currently looking a way around to disable this popup warning.