I wrote/assembled a VBA code in excel that crops a defined range from an excel workbook in which some cells contain text - most plain and some with bold font. I want to harvest that text and turn it into a RTF File that I can finally incorporate as body text of an outlook e-mail - all done by excel VBA code. The problem seems to be the first part because the RTF documents that I originate never maintain the bold font of the lines that I assigned to have bold font. This is the code for creating the RTF document. I tried with Selection. to maintain the formatting properties and I tried with an if-condition assigning bold font to particular cells. Can anyone please tell me why I don't manage in any way to get the defined lines to remain bold in the RTF document? Thanks in advance 

Please Login or Register  to view this content.