How to Bulk Import external email contacts through CSV and adding all the details in it This is the CSV will look like First run this command Import-Csv "E:\contact2.csv" | %{New-MailContact -Name $_.Name -DisplayName $_.Name -ExternalEmailAddress $_.ExternalEmailAddress -FirstName $_.FirstName -LastName $_.LastName} The initial mail contacts will be created which can be visible through GAL. If you will check into Exchange control panel under Contacts it will look like this But remember details will be filled only in GENERAL tab If want to add additional details then run the second script as well importing the same CSV file again like this Import-Csv "E:\contact2.csv" | foreach {Set-Contact $_.externalemailaddress -Name $_.name -FirstName $_.firstname -LastName $_.lastname -StreetAddress $_.streetaddress $_.province -City $_.city -PostalCode $_.postalcode -MobilePhone $_.mobile $_.workphone -HomePhone $_.homephone -Company $_.company -Title $_.title $_.department -CountryOrRegion $_.countryorregion -Fax $_.fax -Notes $_.notes -Office $_.office}
How to Bulk Import external email contacts through CSV and adding all the details in it This is the CSV will look like First run this command Import-Csv "E:\contact2.csv" | %{New-MailContact -Name $_.Name -DisplayName $_.Name -ExternalEmailAddress $_.ExternalEmailAddress -FirstName $_.FirstName -LastName $_.LastName} The initial mail contacts will be created which can be visible through GAL. If you will check into Exchange control panel under Contacts it will look like this But remember details will be filled only in GENERAL tab If want to add additional details then run the second script as well importing the same CSV file again like this Import-Csv "E:\contact2.csv" | foreach {Set-Contact $_.externalemailaddress -Name $_.name -FirstName $_.firstname -LastName $_.lastname -StreetAddress $_.streetaddress $_.province -City $_.city -PostalCode $_.postalcode -MobilePhone $_.mobile $_.workphone -HomePhone $_.homephone -Company $_.company -Title $_.title $_.department -CountryOrRegion $_.countryorregion -Fax $_.fax -Notes $_.notes -Office $_.office}