Forum Discussion
Import contacts from parent company
We have a parent company with a separate Office 365 and Exchange Online. I have to import there contacts into our system. I see an option to export, but not to import. The systems are not connect...
I recently ran into the similar scenario with a client. If you have the export in a CSV file you can use PowerShell to create the mail objects, using the New-MailContact cmdlet.
This is assuming you have column headers "DisplayName, PrimarySMTPAddress"
You could use something like this:
$csv = <Path to CSV>
$import = Import-Csv $csv
$import | Foreach {
New-MailContact -Name $_.DisplayName -ExternalEmailAddress $_.PrimarySMTPAddress
}
- And for contact sync, include an export of the legacyExchangeDN value at source and import it as an additional proxyAddresses attribute starting "X500:" (that is, add X500: to the legDN value when importing it)
