How to extract email addresses from mail folders in Outlook?
It is easy to extract email addresses from one email message with copying and pasting. But how to extract all email addresses from folders in Microsoft Outlook? Here we will walk you through extracting all email addresses from specified folders in Microsoft Outlook, and exporting as other files in detail.
- Extract email addresses from a mail folder in Outlook
- Extract Email Addresses from Mail Folder and save as contacts in Outlook
- Extract email addresses from mail folder and save as Contact Group members
Extract email addresses from a mail folder in Outlook
The following steps will guide you to extract email addresses from specified message folders in Microsoft Outlook at ease.
1. Open the Import and Export dialog box:
A. In outlook 2007, please click the File > Import and Export.
B. In Outlook 2010, please click the File > Open > Import.
C. In Outlook 2013, please click the File > Open & Export > Import / Export.
2. In the Import and Export Wizard dialog box, please select the Export to a file, and then click the Next button.
3. In the Export to a file dialog box, please select the Comma Separated Values, and then click the Next button.
Note: In Outlook 2007 and 2010, it’s alternative to select the Comma Separated Values (Windows), Microsoft Access 97-2003 or Microsoft Excel 97-2003 in this step.
4. In the Export to a File dialog box, select a mail folder that you will extract email addresses from, and then click the Next button.
5. In the new Export to a File dialog box, please click the Browse button.
6. In the Browse dialog box:
1) Open a folder where you will save the extracted email addresses.
2) Enter a name for the extracted file in the File name: box.
3) Click the OK button.
7. Click the Next button.
8. In the Export to a File dialog box, please click the Map Custom Fields button.
9. Then the Map Custom Fields dialog box comes out.
1) Click the Clear Map button.
2) Select the From: (Address) in the From: box, and then drag it to To: box. Drag the To: (Address), CC: (Address), and BCC: (Address) to To: box with the same way. See the following screen shot:
3) Click the OK button.
10. Click the Finish button.
It may take several minutes to extract all email addresses in the fields of From, To, CC, and Bcc from the folder you specified in the Step 4.
Extract Email Addresses from Mail Folder and save as contacts in Outlook
If you have Kutools for Outlook installed, you can apply its Add from Message feature to extract all email addresses from all emails in a mail folder, and then save as individual contacts quickly in Outlook.
Kutools for Outlook: Add more than 100 handy tools for Outlook, free to try with no limitation in 60 days. Read More Free Trial Now
1. Open the specified mail folder, press Ctrl + A keys to select all emails, and then click Kutools Plus > Add from Message.
2. In the Add a contact from a message dialog, please specify a contact folder you will save the new contacts to, and click the Start button. See screenshot:
3. Now all email addresses are extracted. Please click the OK button and Complete button successively to finish the work.
Shift to the specified contact folder, you will see all email addresses of senders and recipients are extracted from emails in the certain mail folder, and save as separate contacts in bulk.
Extract email addresses of senders/recipients from mail folder and save as Contact Group members
Kutools for Outlook also provides the Add to Group feature to extract email addresses of senders or recipients from all emails in a certain mail folder, and save extract email addresses as contact group members in bulk.
Kutools for Outlook: Add more than 100 handy tools for Outlook, free to try with no limitation in 60 days. Read More Free Trial Now
1. Open the certain mail folder, press Ctrl + A keys to select all emails, and click Kutools Plus > Add to Group.
2. In the Add Recipients to Contact Groups dialog, please select All senders, All recipients, or All from the Scope drop down list, check the specified contact group you will save extracted email addresses to, and click the OK button. See screenshot:
Now all email addresses of senders or recipients of all emails in the certain mail folder are extracted and saved as the certain contact groups' members.
Demo: extract email addresses from mail folder in Outlook
Tip: In this Video, Kutools tab is added by Kutools for Outlook. If you need it, please click here to have a 60-day free trial without limitation!
Kutools for Outlook - Brings 100 Advanced Features to Outlook, and Make Work Much Easier!
- Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by custom; Auto Reply without exchange server, and more automatic features...
- BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
- Reply (All) With All Attachments in the mail conversation; Reply Many Emails in seconds; Auto Add Greeting when reply; Add Date into subject...
- Attachment Tools: Manage All Attachments in All Mails, Auto Detach, Compress All, Rename All, Save All... Quick Report, Count Selected Mails...
- Powerful Junk Emails by custom; Remove Duplicate Mails and Contacts... Enable you to do smarter, faster and better in Outlook.
