I'm currently building a macro that is supposed to copy a formatted cell content (I.E.: a cell with bold, italic and some coloured text like below)

cell.png

Everythings is fine, the only problem is that my email body should show the copied content after some previously message but it is showing the cell message BEFORE my fixed message.

To make it more understandable, the correct way should be like the following.

"Good morning Mr. X" -> That's a fixed auto generated message

"I want this text .... " -> this text I would change when interest me, since it comes from a cell


Does someone know how to do it?

I'm also pasting my code:

Please Login or Register  to view this content.

My problem are between lines 39 and 68.

Cheers.