# Outlook – Contacts don’t appear in contact book, but they appear in ‘To’ field. Why

microsoft-office-2007microsoft-outlook-2007

When creating a new email in Microsoft Outlook 2007 all the contact's I've ever contacted appear as they should in the 'To' field when I start to type.

The problem I'm having is I need to save them to an Excel sheet but I don't want to go through each one and type them out manually so I was going to export my address book. When I looked in the contact's section there weren't any contacts there.

How do I access the contacts that are showing up in the 'To' field?

%APPDATA%\Microsoft\Outlook

The entries are stored in the file with the extension nk2. If there is more than one file, then it will be the one that matches the name of the Outlook profile you are using.