Ignore Outlook security warning when sending email 2

[aas1611]

Hi,

I want to send an email automatically to about 40 recipients, something like newsletter. A security warning window appears for each recipient, asking if I allow this. So much for automation!

Is there a way to avoid/ignore this? Or maybe a script that automatically clicks "Yes" after 5 seconds?

I have used both SendObject and CreateObject("Outlook.Application") methods. Both sends the email but the security warning still appears.

And, a minor problem: how to set the address of the sender and/or reply to?

Thanks for any hint!

Andre

 

[Ed2020]

Andre,

I don't think you can. I believe this is a security measure to prevent malware from controlling Outlook to send SPAM, viruses, etc. Providing a workaround for this in VB would defeat the object.

Ed Metcalfe.

Please do not feed the trolls.....

 

[PHV]

Do a google search for outlook object model guard
Workarounds keywords: ClickYes, Redemption, CDO, ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ed2020]

I stand corrected.

Please do not feed the trolls.....

 

[seaport]

I agree with Ed.

Andre, I had a similar situation as yours. I used CreateObject("Outlook.Application") method. The way to make my life a little bit easier was to use objEmail.Display instead of objEmail.Send.

This way, I got about thirty email drafts. The security alert appears only once. After all drafts were generated, I just clicked the Send button for thirty times (I can do that in 5 seconds!) and all emails went to Outbox.

Seaport

 

[aas1611]

Well,

I followed PHV's advice to google these keywords. And I found a script ClickYes. It works. Thanks PHV!


seaport,
I don't thinks my colleagues and/or my boss like to click 40 times, no matter how fast they can click. )
But seriously, 30 clicks in 5 seconds? Wow. I don't think my mouse can react that good...

Thanks!

Andre

 

[NvrSaDi]

Thanks PHV for the input.
This has been a major headache at our end.

 

[mp9]

Outlook Redemption is another workaround that solves this annoyance very well. From memory, the URL is

http://www.dimastr.com/redemption

http://www22.brinkster.com/accessory/