Open a Msg File from Access

[neemi]

Does anyone have any thoughts on which is the best way to open a .msg file from within access.

I have a continuous form with a list of emails attached to a record. On there there is a View email button which the user should be able to press to view the email.

I was think of some how embedding the email to a form so that I can control what the user can do with the email. eg. enable, etc.

Can this be done.

How can I open a msg file from within access? Whether this is in another form or just the msg file alone.

Help and thoughts appreciated.

Cheers,
Neemi

 

[Meric1]

Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem

Set objOutlook = New Outlook.Application
Set objOutlookMsg = objOutlook.CreateItemFromTemplate (<FilePath>)

You can access all features of the message from this objOutlookMsg object. If you try to access the e-mail addresses (from, to, cc, etc) then you'll see an Outlook security warning.