View Full Version : Opening a mail from Access


harrisw
07-25-2002, 07:56 AM
How can I open a .msg outlook file using code within Access 97.

I know that

Set MyItem = spObj.CreateItem(olMailItem)
MyItem.Display

Opens a new mail, but I don't know what opens an existing one that is store in a directory somewhere.

Anyone help?

Travis
07-25-2002, 01:13 PM
See Microsoft Knowledge base article:

HOWTO: Use OLE Automation with Microsoft Outlook 97
ID: Q170262


It has sample code on how to retrieve Mail Messages using VBA

harrisw
07-26-2002, 12:43 AM
Had a look but doesn't tell me how to open an e-mail that is stored on the harddrive as a .msg file.

The article in microsoft only tells you how to retreive it from within outlook.