Exporting Exchange public folder contacts to Microsoft Excel

1. From within Microsoft Outlook, you'll want to navigate to the Exchange Server public folder that contains the contacts.

2. Then select File -> Import and Export -> Export to a file -> Next -> Microsoft Excel -> Next -> and then select the appropriate contacts for export.

3. Select Next once more and give the target file a path and name.

4. Click Finish and you should be all set with the Excel file you're looking for.

When I select File -> Import and Export -> Export to a file -> Microsoft Excel -> Next, it doesn't allow me to select the contacts for any public folders. It only gives me the option to select contacts from my mailbox.
—Daniel R.

******************************************

I'm sorry, I forgot that the export user interface only lists personal contacts data sources. Unfortunately, that means you'll need to create a temporary folder in your mailbox that contains contact items, drag the public folder contacts into that folder, and then export from there instead.

I hope that helps. Thanks for writing back in.
—David Sengupta, Server Administration Expert

Related information from SearchExchange.com: