How to collect all autocomplete email addresses in outlook and store them in contacts to export?

Posted on 2007-10-11
Last Modified: 2009-03-17
I will be likely stopping using MS Outlook soon and switching to Gmail.

How do I collect all autocomplete email addresses in outlook and store them in contacts to export as a csv? I know how to do the export to csv - I just don't know how to get all my autocompletes to the contact list list.

Question by:edwardt
    LVL 97

    Assisted Solution

    Greetings edwardt !

    The names are kept in a NK2 file.  With Outlook close, search for *.NK2 and open with one of these editors

    Move the emails to Excel spreadsheet and save it as CSV file.

    .NK2 file is located in
    C:\Documents and Settings\<user>\Application Data\Microsoft\Outlook folder. It is a hidden file. Go to any folder and select Tools > Folders Options > View. Check "Show hidden files and folders".  Click OK.

    Hope this helps, war1

    Author Comment

    Thanks for pointing out the file - the unfortunately doesn't seem to work (run time error). Is there an in-Outlook method to get the data and export it or another free tool?


    LVL 3

    Accepted Solution


    War1 put you right on it.  I have used both the suggested products effectively.  Here is another free tool you can try.

    If that doesn't get if for you google for something like open .nk2 files.

    LVL 97

    Expert Comment

    by:war1 should work.  Make sure PST file is not write protected.

    Author Comment

    Thanks to both - the worked well, except I had to use their "to html" to copy it to a .csv format.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Learn more about the importance of email disclaimers with our top 10 email disclaimer DOs and DON’Ts.
    Set OWA language and time zone in Exchange for individuals, all users or per database.
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now