CODEWITHSUNDEEP
powershellmappingoutlook-2016
Kahn Kah
Kahn Kah

Reputation: 1453

Importing contacts with custom fields only in Outlook 2016

So I have a contact list in a .csv list that looks like:

enter image description here

What I'm trying to do is import this list to my Outlook (Office 365). I started with creating the custom fields inside Outlook.

But I have discovered that it's impossible to use custom fields for mapping when Importing a contactlist:

enter image description here

This because Outlook does not allow custom fields to be selected when importing contacts.

I have tried using software like QuickPort and it does allow me to map the fields but it retrieves the contacts with empty fields only. This means I get x new contacts but all fields are empty.

Is there an alternative way to solve this?

I have checked to map custom fields using the Outlook API in PowerShell but haven't found any solutions.

Upvotes: 0

Views: 1174

Answers (1)

llama
llama

Reputation: 1651

It's as I thought. Outlook expects a comma delimited csv file. I think the file you are using is semicolon delimited. Please try the importing process again, but save your excel file comma delimited see here for instructions.

you can see the ACTUAL format of your csv file by opening it in a txt editor (notepad++ etc)

It seems you have to change your regional settings to make comma the delimiter. See this answer.

Upvotes: 1

Related Questions