How to import .CSV as external contacts in Exchange?

What you need:

• Microsoft Exchange Server
  • In this guide ,we are using Microsoft Exchange 2010.
• A specially formatted .CSV file.
  • This is illustrated below.

Step 1:

Create a .CSV file with this format:

Save it as contacts.csv. For the purpose of this guide, I have saved it to D:\contacts.csv

Also, make sure you have the Organizational Units (OUs) created in your Active Directory before proceeding. If not, you will get an error in Step 3.

Step 2:

Launch Exchange Management Shell.

Step 3:

Once it launches, type the following code: Import-Csv D:\contacts.csv | ForEach-Object { New-MailContact -Name $_."Name" -ExternalEmailAddress $_."Email" -FirstNa me $_."FirstName" -OrganizationalUnit $_."Oupath" -Alias $_."Alias" }

Hit Enter and you are done!

(header image source: freecodesource.com)