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
![Log Out of Outlook](./images/2266116040--crop-342-184-245px-Log-Out-of-Outlook-Step-6-Version-5.webp)
![Print Email from Outlook](./images/2389126727--crop-342-184-248px-Print-Email-from-Outlook-Step-38.webp)
![Set Up Out of Office in Outlook](./images/1694906706--crop-342-184-245px-Set-Up-Out-of-Office-in-Outlook-Step-17-Version-3.webp)
![Open Winmail.dat](./images/1509240672--crop-342-184-245px-Open-Winmail.dat-Step-22-Version-2.webp)
How to
Open Winmail.dat
![Recall an Email in Outlook](./images/962932528--crop-342-184-245px-Recall-an-Email-in-Outlook-Step-25.webp)
![Download Emails from Microsoft Outlook](./images/2331130168--crop-342-184-245px-Download-Emails-from-Microsoft-Outlook-Step-43.webp)
How to
Download Emails from Microsoft Outlook
![See Unread Emails in Outlook](./images/2750165070--crop-342-184-246px-See-Unread-Emails-in-Outlook-Step-8.webp)
How to
See Unread Emails in Outlook
![Sync Outlook Signatures](./images/1235105059--crop-342-184-246px-Sync-Outlook-Signatures-Step-24-Version-2.webp)
![Update Outlook on PC or Mac](./images/2561422896--crop-342-184-245px-Update-Outlook-on-PC-or-Mac-Step-12-Version-2.webp)
![Change Microsoft Outlook Password](./images/3875749024--crop-342-184-245px-Change-Microsoft-Outlook-Password-Step-18-Version-3.webp)
How to
Change Microsoft Outlook Password
![Create an Outlook Email Account](./images/3766956297--crop-342-184-187px-Create-Outlook-Email-Account-Step-8.webp)
![Set Up Outlook Email on an iPhone](./images/2057583357--crop-342-184-245px-Set-Up-Outlook-Email-on-an-iPhone-Step-13-Version-2.webp)
How to
Set Up Outlook Email on an iPhone
![Use the Voting Buttons in Outlook](./images/1172976941--crop-342-184-245px-Use-the-Voting-Buttons-in-Outlook-Step-18.webp)
How to
Use the Voting Buttons in Outlook
![Disable “Work Offline” in Outlook](./images/2055289383--crop-342-184-245px-Disable-“Work-Offline”-in-Outlook-Step-9.webp)
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