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
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.
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.
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.
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.
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.
- 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.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.· 2 years agoHi I did this last week with my sent emails folder and it worked perfectly. When I try it again now, the map custom fields and next button are both greyed out. Tried it with different folders and .pst files. Haven't changed anything. Not sure why its not getting through. Anyone has faced this issue?
- To post as a guest, your comment is unpublished.· 2 years agothanks, very useful
- To post as a guest, your comment is unpublished.· 3 years agoThanks, I got Extract my mail id with the help of you....
- To post as a guest, your comment is unpublished.· 3 years agoIf i send someone an email and BCC a third person, can that third person export the email address of the person i sent the email to from their email?
- To post as a guest, your comment is unpublished.· 2 years agoYes. The third person on BCC will see all information of the email except for other persons on BCC.
- To post as a guest, your comment is unpublished.· 3 years agoSame question as jc
- To post as a guest, your comment is unpublished.· 3 years agoGreat explanation. Exactly what I was looking for.
- To post as a guest, your comment is unpublished.· 3 years agoThank you for your support and the good explenation!
- To post as a guest, your comment is unpublished.· 4 years agoHow to extract email addresses from mail folders in Outlook?
=> is it possible to include the subfolders ?