|If I am not mistaken, you are passing this as text to an email correct?|
If that's the case, then I don't think you can do it. Even if you were keeping this within an Excel sheet and putting the text in a cell, you couldn't store the formatted text in the cell. You have to put the text in the cell and then apply the formatting via more VBA code. It's 2 completely separate operations.
Since you are passing this text to another application, I believe that the only think you'll get is the text and all formatting would have be done in the other app.
I could be wrong...feel free to do some web searches on the matter.,
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03