How to open a .msg file in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric van Nierop - 16 Jul 2005 18:04 GMT

In Acces I made a program to save selected Emails from Outlook2000 to
specified folders on my disk.
It makes a .msg file from the Email, using Subject a a Filename.
For each Email I also make a record in a n Access Table.
Now I want to retrieve Emails in a Form by selecting a record in that table.
What is de VB code in Access to open any .msg file as an Email, just like
when I dubbelclick in Explorer on de msg file?
Thanks for any reaction.

Reply to this Message

Michael Bauer - 17 Jul 2005 09:07 GMT

Eric, in VB you can use the Win32 API ShellExecute. If you need access
to the opened item however I´d use the Outlook function
CreateItemFromTemplate.

Signature

Viele Gruesse / Best regards
Michael Bauer - MVP Outlook

> In Acces I made a program to save selected Emails from Outlook2000 to
> specified folders on my disk.
[quoted text clipped - 4 lines]
> Email, just like when I dubbelclick in Explorer on de msg file?
> Thanks for any reaction.

Reply to this Message

Lynn - 31 Jul 2005 03:42 GMT

eric,
i would like to adopt your solution too.
can you post the code to me?
thanks

> In Acces I made a program to save selected Emails from Outlook2000 to
> specified folders on my disk.
[quoted text clipped - 4 lines]
> when I dubbelclick in Explorer on de msg file?
> Thanks for any reaction.

Reply to this Message