Bulk update/edit mail contacts on exchange using powershell

Question

Uploaded 700 contacts without realizing I had erased all white space from full name on csv file.

Since I also need to update details of existing external mail contacts on exchange (Name, FirstName, LastName, StreetAddress, City, StateorProvince, PostalCode, Phone, MobilePhone, Pager, HomePhone, Company , Title, OtherTelephone, Department, CountryOrRegion, Fax, Initials, Notes, Office, Manager),

can someone help me with writing a code/script for PowerShell to upload the correct csv to update contact details in bulk?

Answer

You can try something like this:

# The CSV **must** contain these column names
# They correspond to the parameter names for the Set-Contact cmdlet
# IDENTITY, City, StateorProvince, PostalCode, Phone, MobilePhone, Pager, HomePhone, Company, Title, OtherTelephone, Department, CountryOrRegion, Fax, Initials, Notes, Office, Manager

$contacts = Import-CSV c:\junk\data.csv
$columns = $contacts[0].psobject.properties.names   # get the list of column names in the CSV

# create the hash only once and populate the parameter names (but no values)
$splat = @{}
$columns |
    ForEach-Object{
        $splat[$_] = ""
    }

ForEach($contact in $contacts){
    # load the hash with values each time
    $columns |
        ForEach-Object{
            $splat[$_] = $contact.$_
        }
    Set-Contact @splat
}

Share via

Bulk update/edit mail contacts on exchange using powershell

1 answer

Your answer