Sergey --
I took the HTML and use STRtoFile to put into into a file, which when opened in Word looks just like I want. So it appears that the HTML is OK.
So, the culprit must be in the way I'm sending the email. As noted, HTMLBody gives only partial results. Would you know if there are other parameters to pass it?
Alternatively, can you suggest an alternative method of sending the email?
Jim
>Hi Jim,
>
>It's hard to tell where formatting gets lost. You may save html to a file and view in a web browser to see if it's copied from Excel correctly.
>
>>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?
Jim Nelson
Newbury Park, CA