Explore this Article
X
wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time.
This article has been viewed 30,360 times.
Learn more...
How to sort your Outlook contacts by whom you've recently e-mailed and then export those contacts to a spreadsheet, database, etc.
Steps
-
1Go to CONTACTS.
-
2Go to VIEW>CURRENT VIEW>PHONE LISTAdvertisement
-
3Right-click on any of the column names.
-
4Select FIELD CHOOSER from the pop-up menu.
-
5In the field chooser pop-up, select ALL MAIL FIELDS from the drop-down.
-
6Scroll to the bottom of the field chooser window until you see the SENT button.
-
7Drag and drop the SENT button to the column names in step 3.
-
8Click on the SENT column name to sort contacts accordingly.
-
9Be aware you're ready to export.
-
10Create a sub-folder within contacts by going to FILE>NEW>FOLDER.
-
11Name this folder accordingly.
-
12Drag desired contacts to new folder.
-
13Go to FILE>IMPORT & EXPORT
-
14Choose EXPORT TO A FILE from the menu.
-
15Select desired format and follow directions.
Advertisement
Warnings
- Exporting to Excel can cause some errant characters. Try exporting to a comma separated values file (CSV).⧼thumbs_response⧽
Advertisement
You Might Also Like




How to
Open Winmail.dat


How to
Download Emails from Microsoft Outlook

How to
See Unread Emails in Outlook



How to
Change Microsoft Outlook Password


How to
Set Up Outlook Email on an iPhone

How to
Use the Voting Buttons in Outlook

How to
Disable “Work Offline” in Outlook
Advertisement
About This Article
wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time. This article has been viewed 30,360 times.
How helpful is this?
Co-authors: 6
Updated: January 30, 2021
Views: 30,360
Categories: Outlook
Advertisement