Asked By
Judy Plum
120 points
N/A
Posted on - 02/01/2013
I want to create a spreadsheet of email addresses from a bunch of emails I received from Outlook 2010. Is there an export option in Outlook 2010? Older versions used to have this option. Need help on how to extract emails in Outlook. Thanks.
How to extract emails in Outlook?
Hello
Follow these steps:
1. Go to File -> Options
2. In Options windows select Advanced and click Export
3. In Import and Export dialog select option "Export to file"
4. Click next and select Outlook data file
5. Select headers you want to export
6. Browser for location where you want to export your file
7. You'll see dialog appears, input password two times and we are done.
You can find illustrations here:Â http://www.cumc.columbia.edu/it/howto/exchange/exp.html
How to extract emails in Outlook?
Â
Hi  Judy PlumÂ
Â
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
Â
Regards