OL98: How to Store Outlook Messages in a MS Access Database
ID: Q181426
|
The information in this article applies to:
-
Microsoft Outlook 98
-
Microsoft Access 97
SUMMARY
This article describes how to store sent e-mail messages in a Microsoft
Access 97 database file.
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, click New Database on the File menu,
and on 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, 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.
Additional query words:
Keywords : kbinterop kbconversion IntpOff
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbhowto
|