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 workPlease Login or Register to view this content.
Bookmarks