Extracting Email Address from Outlook 2007 folder

So you have a folder that you keep all your sales inquiries. Now from out of nowhere you are instructed to send each person an email with your company’s new catalogue.
The thought of having to manually go through each email and copy and paste the email address is nauseating and you wonder how many sick days you have left this year…

Before you reach for the phone to call HR, I have a solution for you !

[Update 24 July 2012 – you can get the new solution that extracts email address from folders and subfolders too]

Here is what you do:

  • In Outlook 2007, click on File, Import and Export and the Wizard opens up.
  • Select the option to Export to a File and click on Next
  • Select Microsoft Excel 97-2003 (or a CSV file) and click on Next
  • Select the folder that your sales inquiries reside in and click on Next
  • Click on Browse to select a location and then type the file name that you want to export the information to and then click on Next
  • Here is the important bit – click on Map Custom Fields. This will bring up a list of all the available fields that are available in that folder.
    Since we are only interested in Email address, click on Clear Map and then from the Left side click on From: (address) and drag that to the Right list
  • Click on OK
  • Click on Finish

Now watch the magic happen – all the Email address will be exported neatly into an Excel spreadsheet that you can now manipulate and use as you wish !

[Bonus Material: How to remove duplicates from the Excel file]


You can also check out the How to Extract Folder Name from Outlook 2007

Also you can check out the How to Exctract all Attachment from Outlook to save onto the computer – not one by one

one more to check out: How to search for an Outlook folder by name

This is also available on YouTube for a step by step tutorial:


on “Extracting Email Address from Outlook 2007 folder
111 Comments on “Extracting Email Address from Outlook 2007 folder
  1. Thanks for a brilliant articles. I was hoping you could help me a bit further though please? I was wanting to somehow extract an email address when it is contained in the body part of an email too. So if say someone you knows mentions another person’s email address in their message you can export that or more likely for when your host tells you an email message has failed to deliver you can extract the bad email address from their message out to Excel or Access. I want to run an un-matched query against my address book and the bad email addresses to get rid of them and clean things up a bit. Any help would be great

    • Hi Chris,
      I see what you are trying to do. The problem is that there is no set format for undeliverable emails so extracting the email address so you can remove it from your contacts is not a simple task.
      What you can do is run the same steps as I describe here but also add the BODY to the extract (not just the Email). This will export all the email messages.
      you can then use Excel to open that file, go to the body column and there do a filter on the @ sign. Its not going to be pretty but it will work.
      Idealy you need to get someone to run a script that will search that Body column, find anything with the @ sign, then copy everything from the “space” before the @ sign till the next “space” (ie the email address) to another column.

      • Thanks again. Great advice. I did exactly as you described and copied in the body part too. On that column once exported to Excel I added a module that did just what you said, found the @ then worked right and left to find the space. Works great. I had a few trailing and leading symbols to get rid of but did that in a further column using RIGHT and LEFT FIND functions. Thanks for the initial idea though – that was the hardest part. Have a great Xmas and all the best for 2012

  2. I tried to do this for all of my sent email in preparation for an eblast and it worked very well for items that are still in my sent folder which only went back a few weeks. Is there any way to retrieve email addresses from emails no longer currently in your sent box?

  3. Nice tip, but two problems: You can only do one folder at a time and this is time consuming if you have dozens of folders as I do. Secondly, you have to then parse out all the multiple email addresses from emails where there ware more than one cc. Also very time consuming for multiple files. I finally decided to drop the 25 bucks for ACCM’s email extractor and it solved both these problems, but I have to say it was a little scary buying from a web site in China.

    • Hi – yes there are lots of paid for apps that will automate this process. Some do it better then other, some have more/less features etc. The point I am making is that you dont need to spend money for something that is available for free – just very well hidden for some reason.

  4. Thank you very much – It is a very quick and hassle free method. LAthough for all mail folder, it needs to be repeated :( – But thats a small price for the ease of ops.

    Now if you could tell me if theres is a magic to gathering all the email ids that seem to go in the memory and just appear when we start tying the id in the ‘to’ box.
    Thanks a lot in advance

  5. HEy Techie Guy, Sounds like this has worked flawlessly for others and I tried it but it didnt work for me…could I be doing something wrong? I have one sub box that I want to extract from….I did everything you wrote and when it converted to csv, it only had the FromAddress in column A Could you give me some advise?



  6. Hi Techie,

    This worked great! Thanks for the help…I think I saw some other people post about this, but is there a way to dig into the sub folders as well with out manually going in and selecting each folder?

  7. I had given this project to our IT dept a week ago,we are a ft250 company so have quite a large resource. They were suggesting Macro’s and all other mainy technical answers but none were working. Out of frustration I googled it and this site popped up. After following your intructions I collected 600 plus emails in about 5 mins. I am now going to do the same with my colleagues
    Thank you very much

  8. Pingback: Extracting Email Address from Outlook Folder & Subfolders « The Techie Guy – Liron Segev

  9. Hi – I like this very much, but when I try to select the folder to export from I can only see those in my Hotmail and Personal Folders sections, not in my separate business accounts. For some reason they do not appear in the list – any thoughts please?

  10. Pingback: Remove Duplicate Email Addresses from the Exported Excel File « The Techie Guy – Liron Segev

  11. When I initially commented I clicked the “Notify me when new comments are added” checkbox and now each
    time a comment is added I get three e-mails with the same comment.
    Is there any way you can remove me from that service? Bless you!

  12. it’s very good from last three days , everyday 2 hours i was finding good software to extract Emails from Microsoft outlook 2010 email folder. but today morning i find it , it’s miracle , so simple. God knows all other software will work or not , but this build in export facility from outlook 2010 works very well. thanks your posting.

    • one more thing – the email ids are extracted, duplicates removed. now how does one remove multiple email ids in the same field – i.e. say in ‘TO’ : there are 4 email ids.
      is there a way to remove those

  13. Pingback: TheTechieGuy: 2012 year in blogging « The Techie Guy – Liron Segev

    • IS there an easy way or sw available to
      batch delete email addresses when they are
      bouncebacks? I realize that there are
      many reasons for bouncebacks but
      I looked high and low for a sw or
      solution to easily getting rid of this problem?
      My wife is in charge of a prayer
      email chain and I just sent an email out
      and received back hundreds of
      undeliverable’s and wanted a simple
      solution to removing addresses from
      the emails themselves.

      Brent Carey

  14. Greetings I am so grateful I found your blog page, I really found you by error, while I was researching on
    Google for something else, Anyways I am here now and would just like to say cheers
    for a tremendous post and a all round enjoyable blog (I
    also love the theme/design), I don’t have
    time to look over it all at the minute but I have book-marked it and also added your RSS
    feeds, so when I have time I will be back to read much more,
    Please do keep up the superb work.

  15. Great, fantastic way to get email addresses out of Outlook – Well Done !

    Do you know of a way of extracting addresses from within an folder of emails in Outlook to export into Excel. We have over 1000 of these emails which are all emailed to us from the same third party with lead details in the body of the email we get. At present we cut and paste into Outlook contacts and our Newsletter software but an automated process would be fab. Any ideas ?

  16. Absolutely FANTASTIC!! Thank you so much. We were so worried we would have to buy software in order to import our database! What a legend!!!! Thank you so much!! Ark Animal Centre Puppy Shelter Team ♥

  17. Hey, there seems to be a character limit when exporting from Outlook to Excel. Has anyone found a way to fix this? I am exporting the body of the email into one of the columns, but the email address I need is at the the end of the paragraph, and it keeps getting cut off. Does anyone know of a work around?

  18. phenomenal I must say. often things are parked in front of your eyes and you really feel your stupid once you come to know them. I never thought I was bad with Google search, but my strive since last week made me believe so. I was about to buy outlook email address extractor bad heartedly but this link came in the last pages of the Google results. very very well done. you saved my life.

  19. Pingback: Exporting Email Adresses

Add your comment