email worksheet as rich text
 

I have an order sheet in excel (2002) and use Ron De Bruin's excellent code
to convert to html and email.
However! Some of the orders are 'emailed' to fax. eg. [FAX:name@1234567]
The catch, of course, is that the fax console can't handle html - the layout
of the order sheet is corrupted. I have found that manually changing the
email to send as rich text works.
Does anyone out there have code to convert a worksheet to rich text and
email? Or perhaps another solution?