ron.williams.IT.blog

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

Sort Microsoft Outlook Contacts By Date Created

with 24 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

About these ads

Written by r0nwilliams

October 16, 2010 at 1:34 am

Posted in Office

24 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!!!
    THANK YOU – THANK YOU
    Have a great Holiday :)

    MViera

    December 15, 2010 at 11:07 am

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

      MViera

      December 15, 2010 at 11:09 am

  2. Very helpfull, thanks!!! :)

    Morriah

    April 6, 2011 at 7:13 pm

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

    -RC

    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.

      r0nwilliams

      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?
        thanks
        Pat

        Patrick

        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…

    TNG

    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!!!

    Vicki

    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!

    Kenneth

    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.

    Thanks,
    Matt

    Matt

    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!

    Chris

    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 ?

    Jean-Baptiste

    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).

      Jean-Baptiste

      February 4, 2013 at 5:55 am

  16. Much appreciated. My boss was very impressed.

    BD1ck13

    April 23, 2013 at 1:20 pm


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: