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?
Please Login or Register to view this content.
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.
Please Login or Register to view this content.
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