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
|