View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Miller Dave Miller is offline
external usenet poster
 
Posts: 72
Default Excel Macro to Copy Word Text into an Email

Tyson,

You could create your body in word, then save it as a webpage (.html,
or .htm). Then change your default format in Outlook to HTML. To add
the body from the saved file use this function below:

Change your line to:
..Body = Get_Body


Function Get_Body() as string
Dim ie as Object

With ie
.visible=True
.navigate "C:\Your File Name.html"
Do Until .ReadyState = 4
Loop
Get_Body = .Document.Body.InnerHTML
.Quit
End With

Set ie = Nothing
End Function