Am I a Microsoft Infrastructure technology evangelist? I guess so…

Sort Microsoft Outlook Contacts By Date Created

with 27 comments

Have you ever added someone to Microsoft Exchange sync’d mobile device, then forgotten their name?  BUT you know a general time period of when you added the contact?

Well, I have, and never knew how to find the “created on” attribute… but i guess I never looked very hard.  But tonight I was really feeling frisky and decided to look at all the attributes on an item in Outlook.  There’s a whole bunch of attributes that you don’t normally see, which always kinda gets me interested…   Here’s how to sort your contacts by their creation date, showing the day that you added them to your phonebook or contact list:

In Outlook 2010:

  1. Click on the contacts view in Outlook
  2. Click the View Tab in the Ribbon
  3. Click Change View>List
  4. Click View Settings
  5. Click Columns
  6. From the pulldown menu choose “All Post Views”
  7. Hilite “Created” in the list
  8. Click “Add ->”
  9. If you want, put the Created as the first in the list
  10. Click OK>OK
  11. Sort at leisure!

In Outlook 2003:

  1. Open your contacts view in Outlook
  2. Go to View>Arrange By>Current View>Phone List
  3. Go to View>Arrange By>Current View>Customize Current View
  4. Click Fields
  5. From the pulldown menu, select All Post Fields
  6. Hilite “Created” in the list
  7. Click “Add ->”
  8. Click OK>OK
  9. Check out your new “Created” column in the view. BOOM
  10. Click the Column header to sort by date.

In outlook 2007, it’s probably really similar to OL2010

Written by r0nwilliams

October 16, 2010 at 1:34 am

Posted in Office

27 Responses

Subscribe to comments with RSS.

  1. Ron – You ARE the man!!!!!! There are a lot of articles/blogs etc about this but yours is the clearest and precise solution to this sorting by Created Date!!!
    Have a great Holiday :)


    December 15, 2010 at 11:07 am

    • Hey forgot to mention: THIS WORKS WITH OFFICE 2007 TOO!!!


      December 15, 2010 at 11:09 am

  2. Very helpfull, thanks!!! :)


    April 6, 2011 at 7:13 pm

  3. Thanks very much for this post – SUPER SUPER helpful!


    Rob Currey

    April 20, 2011 at 12:42 pm

  4. Dear Ron,
    it works very well .. but i need a solution to this :
    1-i had X number of contacts on my computer
    2-after exporting the contacts i formatted the computer and configured outlook 2007 and put these X contacts on it
    3-the contacts creation date showed that they were created all in the same date (the date i put the contacts on my new outlook)

    how can i get back the real creation date of each contact??

    thank you

    Abed-R. 'Ghaleb

    July 21, 2011 at 7:23 am

    • Hi Abed: you would have to go back to the original data source for that information, if it still exists. It doesnt sound like you imported the contact creation date into outlook, so there would not be a way, within Outlook, to identify that information.


      July 21, 2011 at 12:32 pm

      • Dear Ron,

        Thanks for the idea of sorting by date.
        However, when exporting the file into Excel, I can´t find the field “Created” in the list. Is that true?


        March 1, 2012 at 5:28 pm

  5. Thank you! Very easy to follow and extremely helpful. One comment: in step 6. under Outlook 2010 change “All Post Views” to “All Post Fields”

    Barry Milberg

    October 21, 2011 at 2:09 pm

  6. Thank you …you saved me to find a contact I created and forgot…


    October 26, 2011 at 8:35 am

  7. Thank you so Much!! You just saved me hours of work, trying to figure out who needed to be added to the Christmas Card List! THANK YOU!!!


    December 1, 2011 at 12:10 pm

  8. Thank You Ron… Installing BCM and this is helpful in cleaning up 10 years for Contacts…

    Jim Betts

    December 7, 2011 at 4:17 pm

  9. Thank you so much, very useful and explained with screenshot very clear!


    December 16, 2011 at 1:53 am

  10. This was exactly what I was looking for. I’m trying to track how many new contacts I add each week to see how effective my networking and referrals are. So I like to sort them by create date and count.

    It worked fine for Outlook 2007, too.



    January 31, 2012 at 12:19 pm

  11. I’m totally loving you right now! That was so easy :)

    Annie J

    July 19, 2012 at 12:14 pm

  12. Thank you so much. You are awesome? I looked for hours to find any kind of answer and yours way right on and easy to follow. Can’t thank you enough. Anne

    Anne Pace

    October 18, 2012 at 3:13 pm

  13. Respect the skillz! much thanks for this tip!


    January 11, 2013 at 2:59 pm

  14. Thank you, it really helped me find a lost contact……. quickly.

    G P Singh, New Delhi, India

    January 14, 2013 at 8:05 am

  15. Very interesting, is there a way to sort MS contacts By user who created the contact ?


    February 4, 2013 at 5:46 am

    • It seems to work with the field “from” but I can’t modify it (or find where we can modify it).


      February 4, 2013 at 5:55 am

  16. Much appreciated. My boss was very impressed.


    April 23, 2013 at 1:20 pm

  17. Thank you! I’ve been trying to figure out how to do this.


    June 10, 2013 at 12:13 pm

  18. This information was a huge help. I did however find slightly different steps:

    Go to Contacts
    Click “List” in the Current View Ribbon
    Click the small arrow in the lower right corner of the View Ribbon Box
    Click “Modify”
    Click “Columns”
    Select “All Mail Fields” from the Drop-Down menu (scroll down)
    Find and highlight “Created”
    Click “Add”
    Click “Move Up” to bring the date to the top
    Click “Created to Sort the List from Newest to Oldest, or click again for the reverse

    Kevin Grail

    March 22, 2014 at 2:25 pm

  19. Thank you sooooo much!! you save so much time!


    July 9, 2014 at 1:35 pm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

%d bloggers like this: