Set textcolor in VBA for email containing form data

Hello, All. New User, first post.

I have a user form to input data into a table which auto-generates an email that also contains the user form data. I would like to change the color of the data that comes from the user form (items in RED below) in the body of the email so the reader of said email can more easily differentiate the form data that has been input. I can find many places to show me how to change color of text strings, but these do not seem to work when applied to the objects from the form. Here is my email code:

Please Login or Register  to view this content.

.Body is a plain text body. You cannot apply formatting to it. You need to use HTMLBody and code the formatting in HTML. The <font> tag is deprecated in HTML5 but I think it still works in Outlook.

BTW Why are you using On Error Resume Next? That will hide errors that you may need to know about.

I have not tested this but here is the idea:

Please Login or Register  to view this content.

Oh, yes. Sorry, I forgot about that. vbNewLine will insert a physical newline character, which will be reflected in the generated HTML, but the rendering engine will ignore it. Add the <br> tags as desired. You can leave in the vbNewLine, but it's not really needed for an email since nobody will ever read the code.