Forum Discussion
Help creating a script to import CSV to update Global Address List
- euanvjc97Feb 03, 2023Copper Contributor
Sorry I don't know why I didn't post the script I have.
I'm just waiting to find out if the csv he is sending me has users that have been removed or if it is just additional users every time. If it is just additional users every time would the below script suffice? I understand if users need removing there would probably be more to it.
Import-Module ExchangeOnlineManagement
$UserCredential = Get-Credential
Connect-ExchangeOnline -Credential $UserCredential
$GAL = Get-GlobalAddressList -Identity "Default Global Address List"
$Members = Import-Csv -Path "C:\Temp\AddressListMembers.csv"
$Members | ForEach-Object {
$Recipient = Get-Recipient $_.EmailAddress
Add-AddressListMember -AddressList $GAL -Member $Recipient
}
Disconnect-ExchangeOnline
@aterneuzenaterneuzen