Microsoft KB Archive/170990: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 60: | Line 60: | ||
=== Creating the Microsoft Access 97 Table === | === Creating the Microsoft Access 97 Table === | ||
# Start Microsoft Access and under | # Start Microsoft Access and under "Create a New Database Using," click "Blank Database," and click OK.<br /> | ||
<br /> | <br /> | ||
-or-<br /> | -or-<br /> | ||
Line 69: | Line 69: | ||
# On the Insert menu, click Table. | # On the Insert menu, click Table. | ||
# In the New Table list, click Design view, and click OK. | # In the New Table list, click Design view, and click OK. | ||
# In the first row of the | # In the first row of the "Table1: Table" in the Field Name field, type <span class="kbd userinput"> Messages</span>. | ||
# Press the TAB key and from the Data Type list, select OLE Object. | # Press the TAB key and from the Data Type list, select OLE Object. | ||
# In the second row Field Name, type <span class="kbd userinput"> Notes:</span>. | # In the second row Field Name, type <span class="kbd userinput"> Notes:</span>. | ||
Line 82: | Line 82: | ||
# Using the right mouse button, click the message that you copied to the Desktop and on the shortcut menu, click Copy. | # 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. | # 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 | # 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. | # Type appropriate text in the Notes column to remind you what message you copied. | ||
# Delete the copy of the message from the Windows Desktop. | # Delete the copy of the message from the Windows Desktop. |
Latest revision as of 11:06, 21 July 2020
Article ID: 170990
Article Last Modified on 1/20/2007
APPLIES TO
- Microsoft Outlook 97 Standard Edition
- Microsoft Access 97 Standard Edition
This article was previously published under Q170990
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, 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