다음을 통해 공유


Exchange 2010: Create mail enabled contacts in bulk

This quick guide will show you how to import a CSV file into Exchange and create multiple contacts:

http://collaborationpro.com/wp-content/uploads/2015/02/Contact-300x77.png

In Excel create 4 Columns:

  • Name
  • Firstname
  • Lastname
  • ExternalEmailAddress

Now from the Exchange Management Shell run the following command:

Import-Csv “contacts.csv” | ForEach {New-MailContact -Name $_.Name -Firstname $_.FirstName -LastName $_.LastName -ExternalEmailAddress $_.ExternalEmailAddress -OrganizationalUnit “Domainname/OUname”}

http://collaborationpro.com/wp-content/uploads/2015/02/Contact2-300x106.png

In the EMS it will go through the list in the CSV file and create the contacts one by one. If there is a problem with a contact, for example it already exists then an error will be displayed and the import will continue.