Hi all,
I have a macro that opens a workbook, filters certian information and e-mails it to various recipents. This all works fine, the only trouble being that for every e-mail sent a message is generated asking if I want to continue. The message is sent to 57 recipents, all containing different filtered data, so this is very time consuming. Is there any way of skipping this message?
Any help greatly appricated.
Thanks,
David
try adding the following command before the command that is generating the alert & another one after it with the it DisplayAlerts = true
Remember that you may not get any messages if something goes wrong after the DisplayAlerts = False command is runCode:Application.DisplayAlerts = False
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Hey,
Thanks for getting back to me. No joy with that one I am afraid. On further investigation the message that comes up looks like it is actully a warning from Outlook, so I am searching through outlook options now to try and find something that will allow me to do this.
Thanks,
David
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks