Suppressing Excel's Pop-ups and Messages

**fabflight** · 06-30-2009, 06:33 AM

Hi,

I've written a script to automatically send an email but a message pops up before every email is sent asking me if it is ok to go ahead with the send.

Is there a function or even a simple setting that exists in Excel to suppress or automatically close such pop-ups?

I'm using Excel 2003 SP3

Many thanks.

**StephenR** · 06-30-2009, 06:41 AM

Try

Please Login or Register  to view this content.

, and turn it back on at the end.

**romperstomper** · 06-30-2009, 08:09 AM

No, I don't believe there is - that sounds like the Outlook Security model. You need to either use CDO to send the email, use Extended MAPI or a library like Redemption that handles that for you, or use a third party program like Click Yes to automatically respond to the prompts.