Q
Problem solve Get help with specific problems with your technologies, process and projects.

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 Exchange Server setup and troubleshooting

    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.

    Please create a username to comment.

    -ADS BY GOOGLE

    SearchServerVirtualization

    SearchCloudComputing

    SearchSQLServer

    SearchEnterpriseDesktop

    SearchVirtualDesktop

    Close