OutlookCSVImport - Import a CSV file into Outlook.
Match up the necessary fields and modify the script if needed. Remove or add any additional fields.
Based on http://tinyurl.com/4uce9k
Download Microsoft Outlook VBA Language Reference for other properties that were not listed here.
There were 4 properties in an export i originally created this for that do not have a corresponding field in Outlook. I added them as part of the Body field (notes field).
The script will add the excel file into the default Outlook Contacts folder. Something to keep in mind while testing :)
Sort the Excel file by the FileAs field. My export came from http://www.codetwo.com/ Outlook export tool.
The client this was made for had custom fields that Outlook would not export out. The third party tool did a great job.
Renamed a few of the custom contact fields to what was needed and set the rest to be part of notes.
Outlook's natural import/export function with the "Map Custom Fields" does not work correctly. Quite a few existing Outlook fields,
do not export or import, even while it creates a csv column entry for the field (nickname is one example).
Called Microsoft on this issue. Will see what answer they come up with.
If the program crashes at any point look for the contact that crashed it, i had a field with a #name? in it that caused a crash.