Exporting Mailboxes with Aliases - OnTheKnows/A GitHub Wiki

$mbxarray = @() $users = Get-Content "C:\temp\strange.csv" foreach ($user in $users) { $mailbox = $user | get-recipient | select DisplayName,PrimarySmtpAddress,EmailAddresses #$mailbox foreach ($emailaddress in $mailbox.emailaddresses) { $mbxarray += @( @{DisplayName=$mailbox.DisplayName;PrimarySmtpAddress=$mailbox.PrimarySmtpAddress;EmailAddress=$emailaddress})} } #| Export-Csv C:\temp\strangers.csv $mbxarray | ForEach-Object {[PSCustomObject]$} | Sort-Object DisplayName | Format-Table DisplayName,PrimarySmtpAddress,EmailAddress $mbxarray | ForEach-Object {[PSCustomObject]$} | select-object DisplayName,PrimarySmtpAddress,EmailAddress | Sort-Object DisplayName | export-csv C:\temp\strangers.csv -NTI