Paste Range Into Email with Formatting Trouble

[bs04do]

Hello,

I have been developing my VBA skills directly through Google and message boards and have become stuck with a certain situation. The following code allows one to copy a certain range and paste this range into a new email through Outlook. The problem I have run into is that the conditional formatting that was in the original file is no longer in the email, however if I were to simply copy/paste the range from excel into a new email manually, the formatting remains.

Is there a way, adjusting the code below, that the formatting can remain?

Thanks!

Please Login or Register  to view this content.