My brother just asked me the following question:

In Outlook, when I start to type an address in the To: field, after three letters, a list of addresses pops up with the full email addresses.  Can I get that list exported out to Excel?

I thought I’d post the solution here to help others that may have the same problem.

To Export to Excel

  1. On the computer with the saved AutoComplete names, go to drive:\Documents and Settings\user name\Application Data\Microsoft\Outlook.
    Note  Depending on your file settings, this folder might be hidden. To view the files in this folder, do the following on XP:
    Click Start, and then click My Computer.
    On the Tools menu, click Folder Options.
    Click the View tab, and then, under Advanced settings, under Hidden files and folders, click Show hidden files and folders.
  2. Go to http://www.nk2.info/ and click the link “Download Link with full libraries” or just click here
  3. Use the application to locate the nk2 file and read the data.
  4. Export to CSV, This file format can be read by Excel.
  5. The Nk2 can be flaky so if your having trouble with it just search Google for ‘NK2 Export’ there are hundreds of other applications that do the same Job (some free some not).

To Move to another computer:

  1. On the computer with the saved AutoComplete names, go to drive:\Documents and Settings\user name\Application Data\Microsoft\Outlook.
    Note  Depending on your file settings, this folder might be hidden. To view the files in this folder, do the following on XP:
    Click Start, and then click My Computer.
    On the Tools menu, click Folder Options.
    Click the View tab, and then, under Advanced settings, under Hidden files and folders, click Show hidden files and folders.
  2. Right-click profile name.nk2, and then click Copy.
  3. 3. On the computer where you want to populate the AutoComplete feature, copy the file to drive:\Documents and Settings\user name\Application Data\Microsoft\Outlook.
  4. If the Outlook user profile name is different on the computer where you are moving the .nk2 file, you must rename the file with the same Outlook user profile name after you copy it to the correct folder. For example, if you move Mbeeby.nk2 from the original computer with an Outlook user profile name of Mbeeby, and the new computer uses the profile martinb you must rename the file martinb.nk2.
  5. When prompted about replacing the existing file, click Yes.
  6. Open Outlook to view changes.

Please Note: Some portions of this document are taken from microsoft online help, which can be found here:

http://office.microsoft.com/en-us/outlook/HA011394511033.aspx