macro to open an existing email message

P

Paul D. Simon

I have saved an Outlook email message as an .msg file. Need an Excel
macro that when run from an Excel worksheet would open that message.
(Also would saving the message as an .html file or .txt file work
better from within the macro?)
 
J

Jules

I have saved anOutlookemailmessage as an .msgfile.  Need an Excel
macro that when run from an Excel worksheet would open that message.
(Also would saving the message as an .html file or .txt file work
better from within the macro?)

You can try this command:
Call Shell("outlook.exe /f " & Chr(34) & "c:\my email.msg" & Chr(34))
It works for every program, every extention.
In case there is a space in the file name you need the "
e.g. not having a space in it gives
Call Shell("outlook.exe /f c:\my email.msg")

Good luck!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top