How to sort your Outlook contacts by whom you've recently e-mailed and then export those contacts to a spreadsheet, database, etc.

Steps

  1. 1
    Go to CONTACTS.
  2. 2
    Go to VIEW>CURRENT VIEW>PHONE LIST
    Advertisement
  3. 3
    Right-click on any of the column names.
  4. 4
    Select FIELD CHOOSER from the pop-up menu.
  5. 5
    In the field chooser pop-up, select ALL MAIL FIELDS from the drop-down.
  6. 6
    Scroll to the bottom of the field chooser window until you see the SENT button.
  7. 7
    Drag and drop the SENT button to the column names in step 3.
  8. 8
    Click on the SENT column name to sort contacts accordingly.
  9. 9
    Be aware you're ready to export.
  10. 10
    Create a sub-folder within contacts by going to FILE>NEW>FOLDER.
  11. 11
    Name this folder accordingly.
  12. 12
    Drag desired contacts to new folder.
  13. 13
    Go to FILE>IMPORT & EXPORT
  14. 14
    Choose EXPORT TO A FILE from the menu.
  15. 15
    Select desired format and follow directions.
  16. Advertisement

Warnings

  • Exporting to Excel can cause some errant characters. Try exporting to a comma separated values file (CSV).
    ⧼thumbs_response⧽
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