Export E-mail Address List From Exchange 2010

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.

The excellent [SOLVED] enterprise I.T. blog has a post on exporting the email list from the shell.  Go take a look at it!

4 Replies to “Export E-mail Address List From Exchange 2010”

  1. I’ve been doing this using a much more complex set of steps from the EMS or using the LDIFDE utility. Your steps came in quite handy as they are much simpler, thanks for taking the time to share this.

    1. There could be. I don’t have access to an Exchange 2013 server to know. I do know this pretty much works on all versions prior to 2010 with more or less the same process. Would assume it works more or less the same way with Exchange 2013, but you might have to poke around in the context menus to find it.

Leave a Reply