Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a macro to open an existing workbook chrism Excel Programming 2 August 28th 07 09:40 AM
macro/sub to copy a specific ws from source wb to open wb and overwrite existing ws nycjdc Excel Programming 3 December 4th 06 10:54 PM
need macro for create new email message and send it [email protected] Excel Programming 4 July 11th 06 11:15 AM
macro to open outgoing message with info Scott Marcus Excel Discussion (Misc queries) 0 June 22nd 06 04:07 PM
Excel open an existing MS Query in edit mode via macro attached to a button. systems analyst Excel Programming 1 October 3rd 03 12:08 PM


All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"