Extracting bounced back email IDs from Outlook : Addressing the pain point in e-mail marketing

Email  marketing is abuzz! 
With great efforts you collect e mail Ids. With greater enthusiasm you send e-mails.
Click Send.
Give the system a sec…A series of bounced mail ids land in to your Inbox…. 
The reason , Wrong Mail Ids…..
Now the job is to compile all wrong mail Ids from all those bounce back mails or Wrong mail Ids. It’s dreadfully painful (Is this expression correct ?)to go to each return mail and collect the Id.
Recently I faced similar challenge! 
I Googled and bumped in to looooong Macros. 
Some suggested Import export…I tried and failed with all those solutions and may be because of ability to understand and execute the solution... and then….
Falsh $#@%^&* Flash…….!
New Idea !   Indian Jugad ! Quick and Dirty !
The Idea is as simple as ... Select , Copy and Paste.
Ctrl + A , Ctrl + C and Ctrl + V.
Here below is the explanation….
Open the  Outlook  .
Keep all mail Delivery failures in a Folder. Now do the following as shown in...
Picture 1 : On the fields bar , Select Field Chooser
Picture 2 : Menu Opens up like this. Drag to  the fields bar
Picture 3 : Now you have  “to” Mail Id and Other fields
Now It's just  Ctrl + A , Ctrl + C .
Open Excel and Ctrl + V.

Bingo… Now you have an excel with a column full of wrong mail Ids....
It was an eureka moment when I found the simplest solutionI was remembering the story...Americans had spent millions of dollars to invent a pen that writes in space where as Russians wrote with pencil !
Jugaad Zindabad


  1. you're a lifesaver!!!

  2. Anonymous26 July, 2013

    This seem to be a simple solution, however where is the "Fields bar" in MS Outlook 2007? I am stuck at the very first step itself..

    Please help.


  3. Hello,

    Well I found the fields bar.. however I have a new query now..

    The mails which I get are "From" : mailer-daemon@googlemail.com, and the "To" field in these mails is going to be my own ID, cause they have mailed me the notification..

    Hence the email IDs which got bounced and which I want to extract are not in the "To" fields but in the "main message". How do I get them?

    1. @Asavari
      I tried and tested again on Outlook 2010 after your comments.
      "To" shows the wrong mail Id/ reject mail Id - not your mail Id as you mentioned. Please try it and confirm.
      I donot think Outlook 2007 will be completely different from Outlook 2010.
      will be able to reach you if you provide your mail Id to communicate.

    2. Hello Satya,

      Sorry, I am using Outlook 2010 only and not 2007.

      I have tried this again, and what I have noticed is, there are few notification which are from "System administrator" which gives me rejected email IDs in the To field, and the mails which are from "Mail delivery subsystem" gives my own ID..

      Anyways, I am atleast getting some of them in excel now..

      Let me know if you know any other solution to this may be using macros..

      Thanks for helping out.


  4. Btw, I got a free tool from net which extracts emails from the mail body too.. and it's very convenient.. gives you output in txt, which you can easily copy paste in excel..

    Here is the link incase you need it in future :

    Thanks once again.


  5. @Asavari, Thanks a lot for your messages. Glad that you found a new tool. Thanks for the link.
    Let me try it. Thanks to the Good Samaritan who created this tool :-)

  6. This is the easiest, quickest way I have ever seen to remove bounced emails. You are my hero!

  7. This software is efficient email extractor software which is capable of extracting email addresses from Microsoft Outlook files. You can also use this software for email extracting.

    For more detail: http://outlookemailfinder.blogspot.in/


  8. Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking. email address

  9. Thanks - that worked and saved a ton effort :). And once you have your CSV file what you can do is:
    -Put Original List in Column A -Put To Remove list in Column B -Select both columns, then "Conditional Formatting"
    -Select "Hightlight Cells Rules" --> "Duplicate Values"
    -The duplicates should be hightlighted in both columns
    -Then select Column A and then "Sort & Filter" ---> "Custom Sort"
    -In the dialog box that appears, select the middle option "Sort On" and pick "Cell Color"
    -Then select the next option "Sort Order" and choose "No Cell Color" "On bottom"
    -All the highlighted cells should be at the top of the list. -Select all the highlighted cells by scrolling down the list, then click delete.

    Credit here: https://stackoverflow.com/questions/12393524/excel-delete-row-if-column-contains-value-from-to-remove-list

  10. Very nice article about software and related information, its very nice article. thanks for sharing such great article hope kee sharing such kind of article email extractor from website

  11. Anonymous24 July, 2018

    Very interesting blog. Alot of blogs I see these days don't really provide anything that I'm interested in, but I'm most definately interested in this one. Just thought that I would post and let you know. hotmail sign

  12. It was very helpful to me. keep posting amazing stuffs. You can try Outlook email extractor tool for extracting email ids from outlook. Thanks

  13. Great post, thank you for sharing. You might also check out improver.io — contact finding Chrome extension. It helps my sourcing routine a lot!candidate email

  14. thank you for your interesting infomation.
    Mason Soiza

  15. This article is very nice and informative, Thanks for Sharing such nice article. its explain lot of technique and Features extract email addresses from outlook

  16. I found a service for email verification called Neverbounce. Can you check it out and tell me if it’s good or worth it?

  17. Love what you're doing here guys, keep it up!.. Email List

  18. It is so useful blog, Thanks for sharing this information. I appreciate this blog's information.
    Please keep sharing this type of blog. web email extractor

  19. If you are running a blog or if you are a web developer then create eBook or demo version software and give your readers free exchange of their email.Email List

  20. I Find it very informative about marketing.Thanks for sharing such great information.Internet marketing is the best way to enhance your business. email marketing software

  21. Thank you so much as you have been willing to share information with us. We will forever admire all you have done here because you have made my work as easy as ABC. click here

  22. Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. buy email list

  23. Excellent information on your blog, thank you for taking the time to share with us. Amazing insight you have on this, it's nice to find a website that details so much information about different artists. Activecampaign Marketing Automation

  24. Great write-up, I am a big believer in commenting on blogs to inform the blog writers know that they’ve added something worthwhile to the world wide web!..
    find social media links

  25. /Let create a new world for yourselft by way take part in the games– sims 4 cheats in my site. Click link to visit site. Thank you so much. sims 4 cheats

  26. thank you for this such a good information about hotmail email login on www.hotmail.com

  27. Any solution for the web version of outlook?