How to Store Outlook 97 Messages in an MS Access 97 Database

Last reviewed: January 19, 1998
Article 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, on the File menu, click New Database 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.

  11. 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.
Keywords          : IntpOff kbinterop
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbhowto


================================================================================


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 19, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.