SendObject inspires Outlook security warning

[Guest]

I'm trying to send individual emails to a recordset of about 700 email
addresses. My code iterates through the recordset, executing the SendObject
method for each, although I'm not really sending an object, just email text.

Each email is triggering an Outlook warning dialog asking whether to permit
access to Outlook.

Do I have to click 'Yes' 700 times or is there a better way?

 

[Rick Brandt]

I'm trying to send individual emails to a recordset of about 700 email
addresses. My code iterates through the recordset, executing the SendObject
method for each, although I'm not really sending an object, just email text.

Each email is triggering an Outlook warning dialog asking whether to permit
access to Outlook.

Do I have to click 'Yes' 700 times or is there a better way?

If you automate CDO (or another messaging library) instead of using
SendObject then you can avoid the prompts. Otherwise you're stuck. There
is a free product that automatically presses the [Yes] button for you, but
that always seemed like a crude answer to the problem to me.

 

[solex]

Yes you have to click yes at the most 700 times, or you can search for
"ClickYes" or "Outlook Redemption"

Also check www.slipstick.com