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

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.

Who is Participating?
fpcitConnect With a Mentor Commented:

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.

war1Connect With a Mentor Commented:
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
edwardtAuthor Commented:
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?


war1Commented: should work.  Make sure PST file is not write protected.
edwardtAuthor Commented:
Thanks to both - the worked well, except I had to use their "to html" to copy it to a .csv format.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.