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.
Try, and turn it back on at the end.Code:Application.DisplayAlerts=False
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.
So long, and thanks for all the fish.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks