Import contacts to outlook 2010 from csv file

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

$sourcePhoneExtensionOrSpeedDial=$contact.PhoneExtensionOrSpeedDial $sourcePhoneAreaCode=$contact.PhoneAreaCode

$sourcePhoneCountrењњode=$contact.PhoneCountrењњode $sourceAddressCountry=$contact.AddressCountry $sourceAddressState=$contact.AddressState $sourceAddressLine3=$contact.AddressLine3 $sourceAddressLine2=$contact.AddressLine2 $sourceAddressLine1=$contact.AddressLine1 $sourceBranchLegalName=$contact.BranchLegalName $sourceLastName=$contact.LastName -replace вЂќ вЂњ,вЂќ-вЂќ $sourceFirstName=$contact.FirstName -replace вЂќ вЂњ,вЂќ-вЂќ $sourceInformalName=$contact.InformalName -replace вЂќ вЂњ,вЂќ-вЂќ # Read all attributes provided by the file # Read contacts and make the magic happen For these cases we will use a -replace option when assigning the value to the variable and replace the spaces with hyphens. FirstName=Mary Jane) which will cause the import to fail. For the name fields there have been some issues where people have names containing spaces (e.g. Next up we will loop through the records and assign working variables to based on the contents of each record. Next we see that the file is imported into the $contactfile as an array.

#Import contacts to outlook 2010 from csv file update#

Note that this is not alwasy 100% effective and may require some tweaking which IвЂ™ll update as I make more progress with the error handling. In this section weвЂ™ve identified the location of the import file (assume X:SCRIPTS for the path and a filename of contacts.csv), as well as setting the alerts to continue on error. Comment this out with a # symbol if you need verbose errors 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 2010 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.

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 2010 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.