How to export all details of Global address book?

Hello, we run Exchange and have Office 2010. Is there a way to export the entire address book to a csv file that will include all information, such as mobile number? I messed with it, but the numbers were not exporting I only see names. Active Directory is where we add the information, then it syncs with exchange. Do I do it via the active director? If so, how? If via outlook, how?

Again, I am wanting to be able to export all numbers attached to the name.




Thanks!

Hello Mike6623,

Have a look at this tutorial at our sister forum.
Pay special attention to step E of part four of option one.


Good luck and keep us posted,
Nommy

Which variety of Office 2010 do you have - is it one of the versions with MS Access?

It's a few years ago that I did this, so maybe different in Office 2010, but I seem to remember that in Access 2003 you could just Link to Exchange as a data source; hopefully Access 2010 can too.

You could then pull the data into an Access table and do whatever you wanted with it, including exporting it.

These days Excel 2010 may be able to to the same, I guess, so you might try that too.

DavidY said:

Which variety of Office 2010 do you have - is it one of the versions with MS Access?

It's a few years ago that I did this, so maybe different in Office 2010, but I seem to remember that in Access 2003 you could just Link to Exchange as a data source; hopefully Access 2010 can too.

You could then pull the data into an Access table and do whatever you wanted with it, including exporting it.

These days Excel 2010 may be able to to the same, I guess, so you might try that too.

Click to expand...

It is 2010 Professional plus

Ah thanks for that - so that means you have Microsoft Access then.

It certainly was easy to link to Exchange in Access 2003, so hopefully it's still easy in 2010.

First, open Access and create a new Database.

I don't have access to a version of Access which links to Exchange, but I think the next step is to look on the External Data tab on the ribbon, then click on the "More" dropdown about a third of the way across. On that dropdown, with any luck you'll have an option for Outlook Folder or maybe for Exchange. Then you select Import (or Link if you'll need to keep doing this on future occasions).

The next bit is where I'm guessing, but hopefully if you look in the next dialog box for Address Books, you should find the Global Address list, and select that.

Once you've got the table imported or linked, Right Click on it and you should be able to Export it to various formats, including CSV (called Text File).

Personally I don't like CSV as a format because if you have commas in the data (quite likely in an Address list), can mess things up, so one of the other formats may be better, depending on what you're trying to do next.

Thanks, I will let you know once I try these steps!

It's weird. When I create the new database and go to import, and I am at the outlook folder, it shows nothing even though there are outlook database files there! It can never be easy

Is there a reason that would happen? Here is what I have in my outlook folder and what I see when trying to import it.

Which option did you use to get to that?

I think you need to click on the "More" dropdown (see my picture) and then Outlook Folder, but the message you have is what you might get if you clicked on the nearby "ODBC Database" option.