Opening a mail from Access

[harrisw]

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]

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]

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.