In the attached, I have a pivot table that I want to include in my email body. I have that part working perfectly.
If I specify an HTML range to include in my email. I lose the text mail body.
It is most likely that I would want to use both: an introductory line or two of text followed by the HTML content.
I suspect that the answer lies in the RangetoHTML Code (which I did not write - I modified it from here: https://www.exceldemy.com/excel-vba-...to-email-body/). I tired "prepending" the text to the HTML code like this:
But that did not seem to worktxtstr = BodyText & "<br><br>" & txtstr & "</br></br>"
Bookmarks