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 first published in March 2006

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

    Pro+

    Features

    Enjoy the benefits of Pro+ membership, learn more and join.

    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.

    0 comments

    Oldest 

    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to:

    -ADS BY GOOGLE

    SearchWindowsServer

    SearchEnterpriseDesktop

    SearchCloudComputing

    SearchSQLServer

    Close