Displaying emails on/from Access Forms

[Richard Hannah]

I have saved emails from Outlook Express with .EML extensions and wish to
display the contents/get at attachements through a control/button on a form.
This wirks fine launching WORD to view documents but Outlook Express ignores
a file name parameter when launched by "SHELL".

 

[Douglas J. Steele]

See whether passing the file name to the ShellExecute API works.
http://www.mvps.org/access/api/api0018.htm at "The Access Web" is a complete
example.

 

[Kevin K. Sullivan]

The Application.FollowHyperlink launches the program associated with any
file's extension. Thus:
---------
Dim strFile as String

strFile = "C:\blah\blah\blah.eml"

Application.FollowHyperlink strFile
----------
will open the message in Outlook Express on your machine. It may open a
different program or none at all on a different machine, depending how the
file associations are set.

HTH,

Kevin

 

[Richard Hannah]

Thanks - solves the problem

The Application.FollowHyperlink launches the program associated with any
file's extension. Thus:
---------
Dim strFile as String

strFile = "C:\blah\blah\blah.eml"

Application.FollowHyperlink strFile
----------
will open the message in Outlook Express on your machine. It may open a
different program or none at all on a different machine, depending how the
file associations are set.

HTH,

Kevin