germanorth.blogg.se - Import contacts to outlook 2007 from csv file

#Import contacts to outlook 2007 from csv file update
#Import contacts to outlook 2007 from csv file full
#Import contacts to outlook 2007 from csv file code

We will step through the script together in sections to show what’s happening along the way. Hold on to your hats because this is a big one. I’ll give the necessary disclaimer here which is that you must run this in a test environment and using the WhatIf parameter first! It’s not that I don’t know that the script works, but regardless of my confidence, it is an absolute must that you test any process in an alternate environment before you go live.

Another important feature we use for testing is the -WhatIf parameter. I’ve used the Write-Host CmdLet to output to screen so that we can troubleshoot and monitor the process during the initial tests. We will use the following CmdLets to accomplish our task: Thanks to the magic of PowerShell this is a fairly simple task.

Check to see if the contact exists in the file.

Read the OU where we store the contacts.

Now we get to the good stuff! Here is the logic of how I built the script that is used: 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)

#Import contacts to outlook 2007 from csv file code

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.

#Import contacts to outlook 2007 from csv file update

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:

#Import contacts to outlook 2007 from csv file full

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.