OL2002: How to Use Your Outlook Items with Other Office Programs (290830)

SUMMARY

This article describes how you can open the items in your Microsoft Outlook folders from Microsoft Access 2002 and use these items with other Microsoft Office XP programs. These procedures provide an alternate method to use the Import and Export feature in Outlook 2002.

MORE INFORMATION

For these procedures to work, you must have both Outlook 2002 and Access 2002 installed. You should also have Microsoft Word 2002 and Microsoft Excel 2002 installed.

Start Access 2002.
Create a new database.
On the File menu, point to Get External Data, and then click either Import or Link Table.
In the Import or Link dialog box, click Outlook in the Files of type box.
In the Link (or Import) Exchange/Outlook Wizard, follow the prompts to select the Outlook folder that you want to access, and then type a name for the new table.

NOTE: The linked tables do not contain any custom fields. Only the built-in fields are included. Also, it does not link all address fields. Only the parsed fields of the Business address are included. Concatenated versions of the other addresses may appear.

After you have the new table of your Outlook items open in Access, you can export them to other Office programs. With your table selected, point to Office Links on the Tools menu in Access, and then click either Merge It with MS Word, Publish It with MS Word, or Analyze It with MS Excel.

You can also export the table in other formats. With the table selected, click Export on the File menu, and then click the format that you want to use when export in the Save as type box.