Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to open an existing email message
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?) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to open an existing email message
On 11 mrt, 18:08, "Paul D. Simon" wrote:
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a macro to open an existing workbook | Excel Programming | |||
macro/sub to copy a specific ws from source wb to open wb and overwrite existing ws | Excel Programming | |||
need macro for create new email message and send it | Excel Programming | |||
macro to open outgoing message with info | Excel Discussion (Misc queries) | |||
Excel open an existing MS Query in edit mode via macro attached to a button. | Excel Programming |