exporting contacts from outlook 2010 to outlook 201

That’s a lot of information and because it comes from an external system, the fields don’t match up one-to-one with the native Microsoft Exchange fields which are associated with a mail contact. PhoneExtensionOrSpeedDial (Extension or speed dial number if it exists) PhoneCountr圜ode (If exists for non-North American numbers) InformalName (If FirstName is different than the name used commonly)īranchCode (Each branch is assigned a code in our example)ĪddressLine2 (Address information if needed)ĪddressCountry (Country in ISO code format) The columns that we receive and a description is shown below: This is a saving grace as we can easily manage the content easily using the column header inside a ForEach loop.

The file that we receive will be in CSV format and has a header row. The script was designed to run using the Microsoft Exchange 2010 Command Shell.

Updates cannot impact existing mailflow (Must update rather than delete and re-create).

Updates will be done programatically and fairly frequently (let’s assume weekly).

We want to display the informal name (i.e.

Source system uses legal name and informal name.

Updates include a number of fields such as address, title, phone number, name.

Display names contain the company name as a suffix to differentiate from employees.

The contacts must appear in the Global Address List along with existing mail accounts.

The requirements for the script are as follows: By this I mean that I haven’t exhaustively documented all of the commands and steps. The article is presented in full length so I apologize for the long read. This article, and the script is designed towards the intermediate to advanced PowerShell admin. Importing and Updating Exchange Contacts from CSVīefore we go further, I want to qualify the process and subsequent script which supports it. The goal of this is to integrate an external company’s list of contacts and some key information into the Global Address List with an identifier on each record showing the company name as part of the display name. I’ve had a very specific requirement to add a list of external contacts into an internal Microsoft Exchange environment.

Exporting contacts from outlook 2010 to outlook 201