Create Email with Report as HTML

[Frank B]

I have a report that I want to include in the body of an
email as HTML. I'll be doing this in VBA. Im thinking I
need to run the report, export it as HTML, open the report
and read all the data into a String, then pass the string
as the Body argument for my "Send Email" routine. Sounds
Kludgy, but my routine needs a String for the Body
arguement.
Would that work?
Thank,
Frank