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

10 comments:

  1. you're a lifesaver!!!

    ReplyDelete
  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.

    Asavari

    ReplyDelete
  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?

    ReplyDelete
    Replies
    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.
      Regards
      Mahesh

      Delete
    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.

      Asavari

      Delete
  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 :
    https://www.corelan.be/index.php/2007/10/14/free-tool-extracting-email-addresses-from-outlook-mail-folders/

    Thanks once again.

    Asavari

    ReplyDelete
  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 :-)

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

    ReplyDelete
  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/

    http://www.windowindia.net/outlook-email-address-finder.html

    ReplyDelete