Hi
I am using a VBA code that sends emails
In a using a string that stores text in a string named Temp_Body then I use a HTMLBody for the text that will be sent in the email
Here is the code that I use:
Is there anyway I can change the color and font of the Temp_Body?
HTMLBody = Temp_Body & vbNewLine & vbNewLine & RangetoHTML(rng)
Thank you in advance for your help.
Last edited by starlev; 05-15-2015 at 11:34 AM.
HTMLBody = "<font color="red">" & Temp_Body & "</font>" & vbNewLine & vbNewLine & RangetoHTML(rng)
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Hi.
I Just tried What you suggested and while trying to compile I received the following error
Syntax error.
please advise
Eli
Ahh yes. You'll need to double up on the quotes within the string.
.HTMLBody = "<font color=""""red"""">" & Temp_Body & "</font>" & vbNewLine & vbNewLine & RangetoHTML(rng)
Thanks again for your help.
I am not sure where to put the "<br/>"
Can you please advise not familiar with HTML.
Stop posting this question, it should be a single thread. I have answered you in the other thread
Posted here: http://www.excelforum.com/excel-prog...ormatting.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks