Opening a mail saved on a drive through VB 1

[timotai]

Hi

I am trying to open a standard mail from a network drive just using a shortcut button in access using VB. Whenever it opens though the mail is an attachment in a new mail.

How do I get it just to open.

Here is my code:

Dim X

X = Shell("Outlook.exe \\Resrstredega003\groupsd2\GIPROJ\Odin_Support\Help_docs_on_RATA_DATA_BASE\P1_Docs\AWARD_Outage.msg", vbNormalFocus)

Many Thanks

Tim

 

[RobSchultz]

Use /f in your command line. The only caveat is that Outlook must be open first otherwise the message opens then closes immediately leaving Outlook running in the background.

It is probably possible (and a lot more reliable) to do this with the Outlook object model.

HtH,

Rob

-Focus on the solution to the problem, not the obstacles in the way.-