In Outlook for Windows, how do I export my messages or folders to a Personal Folder file, Excel workbook, or Access database?

To export Contacts, Calendar, or Tasks folders in Outlook for Windows to an Excel workbook or an Access database, or to export Journal, Notes, or Mail folders to a Personal Folder file, follow the appropriate steps below.

Exporting Journal, Notes, or Mail folders to a Personal Folder file

1. From the File menu, select Import and Export... .
   
   
2. Select Export to a Personal Folder file. In Windows XP, select Export to a file, and then click Next. Then choose Personal Folder file (.pst), and click Next again.
   
   
3. From the list of folders, select the folder you wish to export. Click Next.
   
   
4. Under the option "Save Exported File As:", type the path and name of the file you wish to save as the exported file.
   
   
5. Select Do not Export Duplicate Items.
   
   
6. Click Finish. This will save your Mail, Journal, or Notes folder as a Personal Folder file in the given path.

Exporting Contacts, Calendar, or Tasks folders to an Excel workbook or an Access database

1. From the File menu, select Import and Export... .
   
   
2. Select Export to a File.
   
   
3. Select the Microsoft product (Excel or Access) you wish to export to, and then click Next.
   
   
4. From the list of folders, select the folder you wish to export.
   
   
5. Type the name you wish to assign the file, and include the appropriate extension, such as .xls or .mdb . Click Next.
   
   
6. To change the export fields, click Map Custom Fields. Otherwise, click Finish. This will export your Contacts, Calendar, or Tasks folder to an Excel worksheet or Access database in your My Documents folder on the hard drive.

Note: If you want to export Journal, Notes, or Mail folders to an Access or Excel file, you must install the converters from the ValuPack. For more information, see article 170786 at the Microsoft Help and Support web site.

You can search Microsoft support at:

Also see:

• In Microsoft Outlook, what is AutoArchive, and how do I use it?
• What is Microsoft Outlook?
• In Microsoft Outlook, how can I import address information from an Excel workbook into my Contacts list?
• How do I convert my email address book into a format used by another email program?
• In Microsoft Outlook 2002, 2003, and 2007, what are personal folder files, and how do I create them?
• In Microsoft Outlook, how do I export email messages to a text file?
• In Microsoft Outlook for Windows, how do I export my contacts to Excel or Access?
• In Microsoft Outlook for Windows, what are offline folders, and how do I enable and disable them?
• In Outlook 2000 and earlier for Windows, how do I use information in my Contacts folder to print envelopes for mailing?