SOLVED: How to Bulk Import Contacts into Exchange 2007 2010 2012

I recently needed to add 50 new contacts into my Exchange 2007 server and had no intention of completing this task by manually. I am not the greatest PowerShell guy but I knew this would be easy… and it was.

Create a file named C:\CONTACTS.CSV file like following

Name,DisplayName,EmailAddress,Alias,Title,Company,Department
Tom Test,tomtest,ttest@test.com,ttest,CEO,TGS,Surveys
John Rotten,JohnRotten,john.rotten@test2.com,ttest,Chief Financial Officer, TGS,Corporate

Launch EXCHANGE POWER SHELL and use the following command:

import-csv c:\contacts.csv | foreach { new-mailcontact -alias $_.Alias -name $_.displayName -ExternalEmailAddress $_.eMailAddress -OrganizationalUnit “arcis1.local/Arcis Exchange Resources/TGS-Contacts” }