Occasionally, it may be necessary to export a complete list of email addresses in your Exchange organization. This article will guide you on how to obtain and export all assigned SMTP addresses to a CSV file in Exchange Server or Microsoft 365 (Exchange Online) using PowerShell.<\/p>\n<\/p>\n
Here’s how to connect to your Exchange organization:<\/p>\n<\/p>\n
You have the option to use certificate-based authentication to sign in to Exchange Online<\/a> from within PowerShell.<\/p>\n<\/li>\n<\/ul>\n To view all primary and additional SMTP addresses for a specific Exchange mailbox, run this command:<\/p>\n The proxyAddresses<\/em> attribute is used to set the email delivery address in the on-premises Active Directory.<\/p>\n<\/p>\n A user is assigned multiple additional SMTP addresses, which are preserved in the EmailAddresses string attribute. Other forms of addresses might also exist within this attribute; hence, to obtain a compilation of all the SMTP addresses of a mailbox, execute the command below:<\/p>\n<\/p>\n The following command showcases all primary addresses and aliases for every user mailbox and shared mailboxes in Exchange<\/a> and exports the results to a CSV file<\/a>:<\/p>\n<\/p>\n The Get-Mailbox cmdlet displays only information about users and shared mailboxes.<\/p>\n<\/p>\n In Active Directory (or Azure AD), there may be other types of objects with SMTP addresses assigned (mail-enabled objects): distribution groups<\/a>, contacts, and Microsoft 365 groups<\/a> (Unified Groups in Azure). Use the Get-Recipient cmdlet to list the SMTP addresses of all the objects in an Exchange organization\/tenant:<\/p>\n<\/p>\n In this case, we have a list of the SMTP addresses of all types of Exchange objects. To export only SMTP addresses of a specific object type, add the following parameter to the first cmdlet<\/p>\n Possible types of Exchange objects:<\/p>\n<\/p><\/div>\n<\/p>\nGet-Mailbox testmax |Select-Object DisplayName,PrimarySmtpAddress,EmailAddresses|fl<\/code><\/p>\n\n
SMTP<\/code> address in uppercase<\/em> contains the primary email address.<\/li>\nsmtp<\/code> values are the secondary (alias) email addresses.<\/li>\n<\/ul>\nGet-Mailbox testmax | Select-Object DisplayName,PrimarySmtpAddress, @{Name=\"SMTPAliases\";Expression={($_.EmailAddresses | Where-Object { $_ -match \"^smtp:\" } | ForEach-Object {$_ -replace \"smtp:\",\"\"}) -join \",\" }}<\/code><\/p>\n<\/p>\nGet-Mailbox -ResultSize Unlimited | Select-Object DisplayName,PrimarySmtpAddress, @{Name=\"SMTPAliases\";Expression={($_.EmailAddresses | Where-Object { $_ -match \"^smtp:\" } | ForEach-Object {$_ -replace \"smtp:\",\"\"}) -join \",\" }} | Export-Csv \"C:PSList-All-SMTP-Addresses.csv\" -NoTypeInformation -Encoding UTF8<\/code><\/p>\n<\/p>\nGet-Recipient -ResultSize Unlimited | Select-Object DisplayName, RecipientType, PrimarySmtpAddress, @{Name=\"SMTPAliases\";Expression={($_.EmailAddresses | Where-Object { $_ -match \"^smtp:\" } | ForEach-Object {$_ -replace \"smtp:\",\"\"}) -join \",\" }}<\/code><\/p>\n<\/p>\nGet-Recipient -ResultSize Unlimited -RecipientType your_object_type | \u2026<\/code><\/p>\n\n