Q

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.

We have a Windows 2000 server and an Exchange 2000 server. How can we export Exchange public folder contacts to a Microsoft Excel spreadsheet?
VIEW MEMBER FEEDBACK TO THIS ASK THE EXPERT Q&A.

Good question.

  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.


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:

  • FAQ: Exchange public folders
  • Tutorial: Indexing Exchange public folder content
  • Resource Center: Public folder management tips and resources
  • Resource Center: Contacts and calendars
  • This was last published in March 2006

    Dig Deeper on Microsoft Outlook and Exchange Server Calendar and Contact Management

    PRO+

    Content

    Find more PRO+ content and other member only offers, here.

    Have a question for an expert?

    Please add a title for your question

    Get answers from a TechTarget expert on whatever's puzzling you.

    You will be able to add details on the next page.

    Start the conversation

    Send me notifications when other members comment.

    By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

    Please create a username to comment.

    -ADS BY GOOGLE

    SearchWindowsServer

    SearchEnterpriseDesktop

    SearchCloudComputing

    SearchSQLServer

    Close