Microsoft KB Archive/170990
Article ID: 170990
Article Last Modified on 1/20/2007
- Microsoft Outlook 97 Standard Edition
- Microsoft Access 97 Standard Edition
This article was previously published under Q170990
This article describes how to create a table in Microsoft Access 97 that will store Microsoft Outlook 97 messages.
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
- Start Microsoft Access and under "Create a New Database Using," click "Blank Database," and click OK.
With Microsoft Access running, click New Database on the File menu, and under the General tab, double-click Blank Database.
- In the File Name box, type a file name, such as SentMail, and then click Create.
- In the SentMail: Database dialog box, click to select the Tables tab.
- On the Insert menu, click Table.
- In the New Table list, click Design view, and click OK.
- In the first row of the "Table1: Table" in the Field Name field, type Messages.
- Press the TAB key and from the Data Type list, select OLE Object.
- In the second row Field Name, type Notes:.
- Press the TAB key and from the Data Type list, select Text.
- 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.
- 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
- Start Outlook and open your Sent Items folder.
- From the Messages view, drag a message to the Windows Desktop.
- Using the right mouse button, click the message that you copied to the Desktop and on the shortcut menu, click Copy.
- In Microsoft Access 97, open the Table1 table in the SentMail database.
- 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.
- Type appropriate text in the Notes column to remind you what message you copied.
- 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.
Keywords: kbconversion kbhowto kbinterop KB170990