RangetoHTML function changes formatting of everything after it

Hello all, I am on Excel 2010 VBA. I am using the Ron De Bruin RangetoHTML function to copy and paste sections of a spreadsheet to different email addresses, using an email template that I have created with placeholder text for where the RangetoHTML contents should go. I only needed the RangetoHTML for a certain section of the email body since the rest of the email will be the same for everyone else.

Everything seems to work fine but instead of the replace function just replacing the placeholder text with the range that is copied from the spreadsheet, everything below the range in the email text is now formatted differently even though everything before the pasted range looks correct. Does anyone know how this could be fixed, if at all? The entire code I used is below.

Please Login or Register  to view this content.

Originally Posted by Bernie Deitrick

What happens if you do the insertion of the HTML range last? Switching the order of these two line to this:

Please Login or Register  to view this content.

It does appear to make the same mistake. Also, I think I should have mentioned that the code seems to keep the color and size of the text, but changes the font to Times New Roman which is not what it should be. And also I said everything after the RangetoHTML changed font but I meant everything after it but before the signature (which does still have the correct formatting for some reason).

Originally Posted by Norie

How do you want the body of the email after the HTML section to be formatted?

Does it make any difference if you add opening and closing HTML body tags either side of RangetoHTML(rng) here?

Please Login or Register  to view this content.

Note, I tried posting the tags I mentioned but apparently I broke some sort of security protocol or something in trying to do so.

Anyway, here is a link.

The text after the RangetoHTML and before the signaturshould be Calibri font, size 11, and RGB 31,73,125. So you mean use the literal tags that have the letters html inside or some other combination of html tags (like body or something else)? By the way I am writing it out in words to avoid the same error you mentioned by including HTML tags.