ARCHIVED: In Outlook for Windows, how do I export my messages or folders to a Personal Folder file, Excel workbook, or Access database?
This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.
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.
Outlook 2010
- From the menu, select .
- Click , and then . Click .
- Select the type of file you want to export to ( , , or ), and then click .
- Select the information you want to export (e.g.,
username@indiana.edu
) to export all Outlook data. ,
, ), or select the root folder (the top
folder labeled with your email address, e.g.,
- Click .
- Select
.pst
, click . If you chose Access or Excel, click and then . to choose a name and location for the
file. If you chose to export as a - Optionally, if you chose to export as a
.pst
file, you will be prompted to password-protect the file. If you do not want to, leave both fields blank and click .
Outlook 2007 and earlier
Exporting Journal
, Notes
, or
Mail
folders to a Personal Folder file
- From the menu, select .
- Select Windows XP, select , and then click . Then choose , and click again. . In
- From the list of folders, select the folder you wish to export. Click .
- Under the option "Save Exported File As:", type the path and name of the file you wish to save as the exported file.
- Select .
- Click
Mail
,Journal
, orNotes
folder as a Personal Folder file in the given path. . This will save your
Exporting Contacts
, Calendar
, or
Tasks
folders to an Excel workbook or an Access
database
- From the menu, select .
- Select .
- Select the Microsoft product (Excel or Access) you wish to export to, and then click .
- From the list of folders, select the folder you wish to export.
- Type the name you wish to assign the file, and include the
appropriate extension, such as
.xls
or.mdb
. Click . - To change the export fields, click
Contacts
,Calendar
, orTasks
folder to an Excel worksheet or Access database in yourMy Documents
folder on the hard drive. .
Otherwise, click . This will export your
Note: 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.
This is document agnu in the Knowledge Base.
Last modified on 2018-01-18 12:25:36.