Exporting Exchange public folder contacts to Microsoft Excel
SearchExchange.com expert David Sengupta gives step-by-step instructions on how to export Exchange Server public folder contacts to a Microsoft Excel spreadsheet.
Good question.
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
- From within Microsoft Outlook, you'll want to navigate to the Exchange Server public folder that contains the contacts.
- Then select File -> Import and Export -> Export to a file -> Next -> Microsoft Excel -> Next -> and then select the appropriate contacts for export.
- Select Next once more and give the target file a path and name.
- Click Finish and you should be all set with the Excel file you're looking for.
MEMBER FEEDBACK TO THIS ASK THE EXPERT Q&A:
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
Do you have comments on this Ask the Expert Q&A? Let us know
Related information from SearchExchange.com: