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
- Start Microsoft Access and under "Create a New Database Using," click
"Blank Database," and click OK.
-or-
With Microsoft Access running, on the File menu, click New Database
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" (without the quotation marks).
- Press the TAB key and from the Data Type list, select OLE Object.
- In the second row Field Name, type "Notes:" (without the quotation
marks).
- 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 : IntpOff kbinterop
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbhowto
|