Get-ADGroup "EXA - Year 13 Pupils" | Get-ADGroupMember -Recursive | Get-ADUser -Properties * |Select SamAccountName,Enabled, GivenName,sn,Mail | Export-CSV -Path “C:\Temp\Y13-Email.csv” -NoTypeInformation


Change "EXA - Year 13 Pupils" to AD group name.

Change path - “C:\Temp\Y13-Email.csv

Will give you Username / First Name / Surname / Email

Example request - please send me all email addresses for Y13 - Y13 email group is in OU=EXA Year Groups,OU=Excelsior Academy Security Groups,OU=Security Groups,OU=Laidlaw Schools Trust,DC=laidlaw,DC=internal