asked on

Export email addresses from Exchange

I am looking for a way to export a csv of all the email addresses (primary and secondary) from Microsoft Exchange.
Ideally as simple as possible so it can be done repetatively and easily.

m_tawfick

You will need to use access for this to work:
Start by opening Access, and creating a blank database.
Now select File \ Get External Data \ Import => You will see a standard file open dialog.
In here, you will open the drop-down menu for Files of type, and you should see Exchange() in the list:
As soon as you select that, it will automatically open the Import Exchange/Outlook Wizard.
Select the Global Address List in the tree, and then hit Next.
(Note that you could export other lists using this same method if you wanted to.)
At this point, you will be asked where you want to store the data.
If this is the first time, you will just select new table.
You could alternatively push the data into any table you want, but we're just going to import the whole thing.
Now you should see the new table in your database, and it will contain the entire contents of the global address list.

Hope this helps,
MMT

m_tawfick

Of course from access you can export the table to CSV

m_tawfick

If you have access to the Microsoft Exchange Administrator program, you can use it.
See http://support.microsoft.com/kb/149447

CharlieBeBop

ASKER

I would like to avoid access as it is not always available.

The link you provided is only for Exchange 4.0-5.5, which is extremely rare these days.

I've worked with some VBS scripts that do the job, problem is they get a lot garbage with it that has to be filtered too.

Dave Stringfellow

I found a little python script to do this for me, but outputs it to a text file, it will work with any AD version, and you should be able to change to a CSV very easyly. The output looks like this:

0 'User1' 'CN=User1s' 'User'
MAIN alex@domain1.co.uk
alias alex@domain1.local
alias alex@domain2.co.uk
alias alex@domain3.co.uk

1 'User2' 'CN=User2' 'User'
MAIN chris@domain1.co.uk
alias chris@domain1.local
alias chris@domain2.co.uk
alias chris@domain3.co.uk

2 'User3' 'CN=User3' 'User'
MAIN dave@domain1.co.uk
alias dave@domain1.local
alias dave@domain2.co.uk
alias dave@domain3.co.uk

http://www.danceresort.co.uk/ext.zip

Hope it helps.

Dave Stringfellow

sorry, i forgot to say, you will need to install the software from the URL in the zip file (23Mb)

ASKER CERTIFIED SOLUTION

Camy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial