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:
My problem are between lines 39 and 68.
Cheers.
Bookmarks