Outlook macro to open Excel and check email addresses

    Hi All!


    Is there a macro that would do as above? In Outlook, if I copy a whole bunch of email addresses, 130 let's say, and paste them into the BCc section and then run the macro in question, it would "open/read" an excel spreadsheet with known bad email addresses (bounce backs) and delete them from the BCc field or something to that effect?


    Sounds confusing, but i hope it made sense on some level


    Thanks!!!

    Re: Outlook macro to open Excel and check email addresses


    Where are you copying the email addresses from? You may be easier to copy them into an excel worksheet to start with where all of the know bad email addresses are, have a macro find and delete duplicates, then paste the cleaned list into a new email in outlook.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login