Export E-mail Address List From Exchange 2010

Thanks to: http://aaronsarea.com

If you need a list of your current user list and primary e-mail addresses for whatever reason, it’s an easy thing to carry out with Exchange 2010. No powershell required!

Step 1 - Open up the Exchange Management Console.

Step 2 - Go to the “Recipient Configuration” and click on “Mailbox” on the left hand section of the screen. Make sure the columns you want are displayed in the middle.

Step 3 - On the right hand section click “Export List”. It will bring up a save file dialog box. It will save it as a tab delimited text file.

 Step 4 - You can copy and paste the contents of this file directly into Excel and it will divide everything up into each cell just fine.

If you keep your Active Directory relatively clean you’ll always have an up to date e-mail list to send out when needed, or an easy way to get user lists for the various network appliances that don’t have LDAP connectivity.
It’s also worth noting that a lot of the lists in Exchange 2010 (and probably Exchange 2007) can be exported in this fashion, it isn’t just limited to your mailbox list.

In PowerShell


Method 1: Export list of all email addresses to a .CSV file using Exchange Management Shell (EMS):
Get-Mailbox -ResultSize Unlimited -OrganizationalUnit “OU=Phoenix Users,OU=Phoenix,DC=CONTOSO,DC=COM” |Select-Object DisplayName,PrimarySmtpAddress, @{Name=“EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_.PrefixString -ceq “smtp”} | ForEach-Object {$_.SmtpAddress}}} | Export-CSV c:\export\smtp.csv -NoTypeInformation
Note: you will need to modify the OU Structure and Domain in the command and replace it with your own.

Method 2: Output all email aliases to a txt file using ldifde utility:
ldifde -f c:\emailaddresses.txt -d “dc=contoso,dc=com” -l proxyaddresses -r “(proxyaddresses=*smtp:*@*)”