Almost there ... Using your suggestion of "HTML Format" and cdo.HTMLBody gives most curious results ...

(1) I get all the data, appearing in columns (that's the good news)

However,

(2) No colors
(3) Wrong font size
(4) No column widths
(5) No lines between rows/columns
(6) I get "A" with a little hat on it in places where I would expect CRs (between lines in multiple line column headers).

Ain't that strange?


>IIRC, CDO has HtmlBody property.
>
>>OK, that looks like HTML. Now how do I send an email using that so that the recipient sees it properly?
>>
>>>
>>>You may have better luck with HTML format

...
>>>cf = RegisterClipboardFormat("HTML Format")
>>>...