Outlook : Recreate autocomplete stream data

  1. Import the FirstName, LastName and EmailAddress from all sent emails into individual contacts in the” Suggested Contacts” folder inside of the systems default Outlook profile via:

powershell script “import_sent_contacts_updated.ps1”

2. Export the “Suggested Contacts” folder from within the Outlook “Options > Advanced > Export” feature.  Filterout the fields so only Firstname, Lastname and EmailAddress are exported to an excel file

3. Delete the “Suggested Contacts” list from Outlook

4. Filter out the duplicates via “Filter > Advanced Filter > No Duplicates” from the excel file

5. Extract firstname from email address excel formula where C2 contains the email address:

=IF(ISNUMBER(SEARCH(“@”,LEFT(C2,FIND(“.”,C2)-1))), LEFT(LEFT(C2,FIND(“.”,C2)-1),FIND(“@”,LEFT(C2,FIND(“.”,C2)-1))-1), LEFT(C2,FIND(“.”,C2)-1))


Extract the lastname if format is first.last:

=IF(ISNUMBER(SEARCH(“.”,C3)), RIGHT(MID(C3,FIND(“.”,C3),FIND(“@”,C3)-FIND(“.”,C3)),LEN(MID(C3,FIND(“.”,C3),FIND(“@”,C3)-FIND(“.”,C3)))-1),C3)

6. Create a CSV from the excel file that has 3 columns (Type, Name, Email Address) where:

Type is “SMTP” or “EX” where SMTP=external addresses and EX=Exchange addresses

Name is “Firstname, Lastname”

EmailAddress is the email address

7. Close Outlook

8. Launch NK2Editor and open the steamautocomplete……dat file

9. Delete the contents

10. Action > Import from simple CSV > Select the formatted CSV file we created

11. Save


Outlook 2007 to 2010 and NK2

With Outlook 2010+ on Exchange 2010+ NK2 files are deprecated and replaced with server side(ish) secret listings.

To export 2007 NK2’s seamlessly:

1. copy .nk2 file from user dir (in XP that’s “%USERPROFILE%Application DataMicrosoftOutlook*.nk2”

2. create the new directory “%appdata%MicrosoftOutlook” on the recipient machine

3, drop the copied nk2 in (assuming it’s named Outlook.nk2

4. Setup Outlook 2010 on new PC using the Outlook profile (or match name to nk2 name or vice versa)

5. the nk2 is then imported into the users 2010 profile on the server and renamed .file!