How to export data from a Microsoft Outlook .PST file to a .CSV file

This third-party utility works with .PST files from Microsoft Outlook 2002 and Outlook 2003, and allows you to copy an arbitrary number of fields from email messages in the .PST. The results are written to a .CSV file and can be imported into Microsoft Excel or any other application that uses the .CSV format.

In order to determine which fields to extract, you'll need to edit the .INI file that comes with the program. You define how many fields in each email to look for, which fields to export, and any additional information that might be needed to do the export (such as the field separator character, which is set to a colon [:] by default).

Once you've configured the .INI file, you can run the program, point it at the Microsoft Outlook .PST file to analyze, define the output file, and select which folders to search in the .PST file (a good timesaver if you want to confine the expor

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT .PST Files Stop personal calendar appointments from showing on Exchange Server Import and export .PST files in Exchange Server 2007 Microsoft fortifies Exchange Server with archiving Understand data file storage in Outlook 2007 Roaming and Local folders Problems arise after downloading email to .PST files Migrate Exchange Server mailbox data to a .PST file Top 5 Microsoft Outlook tips of 2008 Eliminate .PST file use for secure email retention in Exchange 2007 Lock down Microsoft Outlook 2007 to prevent .PST file access Migrating .PST files to an Exchange Server information store Outlook and Outlook Web Access Tips Control Outlook 2007 in cached mode settings with group policies Performing advanced search queries in Microsoft Outlook 2007 Group policy settings for Outlook 2007 in cached mode Detecting update rollup and patch failures in OWA How Windows Desktop Search works in Microsoft Outlook 2007 Troubleshoot IIS metabase corruption in Outlook Web Access How a bare-metal restore affects Microsoft Outlook 2007 performance Fix 'Service unavailable' errors and other common OWA login problems Understand data file storage in Outlook 2007 Roaming and Local folders Troubleshooting Microsoft Outlook Web Access logon issues Microsoft Exchange Server Administration Tools Microsoft Exchange Server 2007 performance tutorial How to custom-configure a Microsoft Outlook 2007 install using OCT Top Exchange Server performance monitoring and troubleshooting tools Search and index Microsoft Outlook 2007 public folders Executing an .MSP customization file in Microsoft Outlook 2007 Using the NTBackup tool for Exchange Server backup and recovery Tools to bulk modify Active Directory users in Exchange Server 2003 Free tools keep Microsoft Outlook visible in Windows Vista Setting up email disclaimers and signatures in Exchange Server Tool deploys customized Microsoft Outlook 2007 configurations Microsoft Exchange Server Administration Tools Research

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary Remote Installation Service  (SearchExchange.com) TCPMAN  (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

t to a particular folder).

NOTE: Outlook Mail2Excel does not provide any visual feedback while it is running; the only way to know when the run has concluded is when the program starts responding to user input again. Also, the program may not work properly with Unicode-formatted .PST files. Before attempting to export anything from a .PST file, you should close Microsoft Outlook.

About the author: Serdar Yegulalp is editor of the Windows Power Users Newsletter.

Do you have comments on this tip? Let us know.

Related information from SearchExchange.com:

Please let others know how useful this tip was via the rating scale below. Do you have a useful Exchange Server or Microsoft Outlook tip, timesaver or workaround to share? Submit it to SearchExchange.com. If we publish it, we'll send you a nifty thank-you gift.

Rate this Tip To rate tips, you must be a member of SearchExchange.com. Register now to start rating these tips. Log in if you are already a member. Submit a Tip DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.