Home > Ask the Microsoft Exchange Experts > David Sengupta: Server Administration Questions & Answers > Exporting Exchange public folder contacts to Microsoft Excel
Ask The Exchange Expert: Questions & Answers
EMAIL THIS

Exporting Exchange public folder contacts to Microsoft Excel

David Sengupta EXPERT RESPONSE FROM: David Sengupta

Pose a Question
Other Exchange Categories
Meet all Exchange Experts
Become an Expert for this site


Exchange Server tips, tutorials and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 15 March 2006
We have a Windows 2000 server and an Exchange 2000 server. How can we export Exchange public folder contacts to a Microsoft Excel spreadsheet?


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
David Sengupta: Server Administration
Changing email address formats in Exchange Server 2003
Should you remove .STM files from Exchange Server 2003?
Exchange users receiving email addressed to legacy users
Pushing a public calendar out from a private Exchange account
Import and export .PST files in Exchange Server 2007
Editing Exchange Server public folder permissions
Search and index Microsoft Outlook 2007 public folders
Troubleshooting Microsoft Exchange Server Event ID error 6009
Can't delete old Microsoft Outlook public folders
Can't create mailboxes after virtualizing Microsoft Exchange Server

Microsoft Outlook and Exchange Server Calendar and Contact Management
Exchange Mailbag: POP3 settings and Outlook issues
Synching public and private Exchange calendars
Preventing duplicate SMTP addresses on Exchange
Prevent duplicate appointments in Microsoft Outlook 2003 calendar
Troubleshoot 'System Attendant' error messages in OWA
Stop personal calendar appointments from showing on Exchange Server
Pushing a public calendar out from a private Exchange account
Problems arise after downloading email to .PST files
How to copy and transfer a Microsoft Outlook 2007 auto fill list
Troubleshooting Apple iPhone and Exchange Server integration issues
Microsoft Outlook and Exchange Server Calendar and Contact Management Research

Microsoft Exchange Server Public Folders
Backing up public folders on multiple Exchange servers
Displaying Exchange 2007 public folders in SharePoint
Synching public and private Exchange calendars
Prevent duplicate appointments in Microsoft Outlook 2003 calendar
Restore contacts from an Exchange public folder
Importing a public folder contact list into an Exchange 2007 public folder
Exchange Server public folder rules and memory limits
Editing Exchange Server public folder permissions
Search and index Microsoft Outlook 2007 public folders
Can't delete old Microsoft Outlook public folders

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
public folder  (SearchExchange.com)
rehoming  (SearchExchange.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


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



  • Search and Browse the Expert Answer Center
    Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
    Browse our Expert Advice



    Outlook Web Access (OWA) Tips and Advice
    HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Site Map




    All Rights Reserved, Copyright 2004 - 2009, TechTarget | Read our Privacy Policy
      TechTarget - The IT Media ROI Experts