OL97: How to Store Messages in an MS Access 97 Database

ID: Q170990

The information in this article applies to:

Microsoft Outlook 97
Microsoft Access 97

SUMMARY

This article describes how to create a table in Microsoft Access 97 that will store Microsoft Outlook 97 messages.

MORE INFORMATION

In order to store Outlook messages in a Microsoft Access table, you must first create the table, and then copy the messages from Outlook into the table.

Creating the Microsoft Access 97 Table

 1. Start Microsoft Access and under "Create a New Database Using," click
    "Blank Database," and click OK.

    -or-

    With Microsoft Access running, click New Database on the File menu,
    and under the General tab, double-click Blank Database.

 2. In the File Name box, type a file name, such as SentMail, and then
    click Create.

 3. In the SentMail: Database dialog box, click to select the Tables
    tab.

 4. On the Insert menu, click Table.

 5. In the New Table list, click Design view, and click OK.

 6. In the first row of the "Table1: Table" in the Field Name field, type
    "Messages" (without the quotation marks).

 7. Press the TAB key and from the Data Type list, select OLE Object.

 8. In the second row Field Name, type "Notes:" (without the quotation
    marks).

 9. Press the TAB key and from the Data Type list, select Text.

10. On File menu, click Save and in the Save As dialog box, click OK to

    save the Table1 table. If prompted to assign a primary key, click Yes.

12. Close the Design View window for the Table1 table by clicking the Close

    button in the upper-right corner of the window.

Copying Outlook Message Files into the Database

1. Start Outlook and open your Sent Items folder.

2. From the Messages view, drag a message to the Windows Desktop.

3. Using the right mouse button, click the message that you copied to

   the Desktop and on the shortcut menu, click Copy.

4. In Microsoft Access 97, open the Table1 table in the SentMail database.

5. Using your right mouse button, click the cell in row 1 of the

   Messages column and on the shortcut menu, click Paste. You
   should now see the word "Package" in the Message column.

6. Type appropriate text in the Notes column to remind you what message

   you copied.

7. Delete the copy of the message from the Windows Desktop.

Your message is now stored in a Microsoft Access 97 Database named SentMail. Whenever you want to open the Outlook 97 message from within the SentMail database, you can just double-click on the word package in the Messages column of the Table1 table.

Additional query words:

Keywords          : kbinterop kbconversion IntpOff 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbhowto

Last Reviewed: December 8, 1998