AD tool for bulk importing pupil and staff emails

[andyturpie]

Morning all,

 

Just wondering if there is a simple tool (no powershell experience btw) to bulk insert email addresses into our AD accounts (circa 1,700 users). We have never used exchange(but now outlook 365) and as a CC4 network all the user email address fields are blank. We want to implement two things, one a single sign on with AD, but plus use the email address field to notify users when their password is about to expire.

 

Any advice please?

 

Andy T

[halbaradkenafin]

Morning all,

 

Just wondering if there is a simple tool (no powershell experience btw) to bulk insert email addresses into our AD accounts (circa 1,700 users). We have never used exchange(but now outlook 365) and as a CC4 network all the user email address fields are blank. We want to implement two things, one a single sign on with AD, but plus use the email address field to notify users when their password is about to expire.

 

Any advice please?

 

Andy T

 

If you've got the list of usernames and emails in a csv (or the email address is in a standard format like

 

 

With csv:

Import-Csv -Path "C:\Path\To\File.csv" | Foreach { Set-ADUser -Identity $_.Username -EmailAddress $_.EmailAddress -whatif}

 

Without csv but

Get-ADUser -Filter * -Properties EmailAddress | Foreach { Set-ADuser -Identity $_.SAMAccountName -EmailAddress ($_.SAMAccountName +  @DomAin.tld") -whatif }

 

Just modify the @DomAin.tld to whatever it should be and give it a try, You'll get a huge list of "What If: Performing the operator "set" on target "CN=Someone,OU=Somewhere,DC=Domain,DC=Local" and if you're happy with the results then just re-run the command without the -whatif on the end.