+ Reply to Thread
Results 1 to 22 of 22

HTML code for colors

  1. #1
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    HTML code for colors

    Hi Team,

    I am using a macro to send mails from outlook. i am trying to update the codes with two things.. to change the outlook page color and change the font color of the sentenses..

    Please help me with the code to change the page color..
    I use the below code to select the font and color. With the below code i am able to use only the plain colors like red, black green etc..

    I also need help to update this code so i can use shaded colors with RGB numbers. I tried to replace the below color "Black" with RGB numbers but its not working out.

    Please help me...

    Please Login or Register  to view this content.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: HTML code for colors

    Please Login or Register  to view this content.
    I use W3Schools.com for most of my HTML tag referencing.

    Here's a tutorial specifically on color.
    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!

  3. #3
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    Quote Originally Posted by daffodil11 View Post
    Please Login or Register  to view this content.
    I use W3Schools.com for most of my HTML tag referencing.

    Here's a tutorial specifically on color.
    i used the code but some how it didnt work for me.. the color didnt change..

    i think i am not updating the code in the right way.. below is the code that i used.. please help me to update this..

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    Hi Team, Please help..

  5. #5
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: HTML code for colors

    Please Login or Register  to view this content.

  6. #6
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: HTML code for colors

    Here's an example I use from Excel that combines multiple strings to form dynamic To, Body, and Signature.

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    Quote Originally Posted by daffodil11 View Post
    Please Login or Register  to view this content.
    Unfortunately this code is not working for me.. The color of both font and mail doesn't change..

    Attached is the sample macro file that I am using to send emails..

    Please help me update the HTML body so I can change the colour of both font and mail page..

    Please help..

  8. #8
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    I missed to attach.. Added the sample file now..
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    Hi Team, Requesting for help on this request..

  10. #10
    Forum Contributor
    Join Date
    04-20-2015
    Location
    Switzerland
    MS-Off Ver
    2010
    Posts
    312

    Re: HTML code for colors

    Hi Arun,

    Replace your code with this that should do what you wanted and also fix the problem with the Signature you reported in the other Thread.
    I removed all the Font settings and put the info directly in the Body.
    I left a diffrent font setting for the Signature that you can see how to format individual text different if neccessary

    to change the Background or text put new colorcodes in this line Color is textcolor and background-color is obviously background color
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    Quote Originally Posted by LordLoki View Post
    Hi Arun,

    Replace your code with this that should do what you wanted and also fix the problem with the Signature you reported in the other Thread.
    I removed all the Font settings and put the info directly in the Body.
    I left a diffrent font setting for the Signature that you can see how to format individual text different if neccessary

    to change the Background or text put new colorcodes in this line Color is textcolor and background-color is obviously background color
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Thank you so much.. This was great help.. It's working perfectly fine as expected..

  12. #12
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    I am facing a challenge in the below part of the code.. Need help please..

    I am not able to change the font to any font which has multiple words in the font name..

    For Example, fonts like Arial, calibri is working but fonts like "comic sans ms","Arial black" is not working..

    Please help..

    Please Login or Register  to view this content.

  13. #13
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    I am facing a challenge in the below part of the code.. Need help please..

    I am not able to change the font to any font which has multiple words in the font name..

    For Example, fonts like Arial, calibri is working but fonts like "comic sans ms","Arial black" is not working..

    Please help..

    Please Login or Register  to view this content.

  14. #14
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    Hi Team, Please help..

  15. #15
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: HTML code for colors

    Use the word cursive instead. Outlook will know what you mean.

    Please Login or Register  to view this content.

  16. #16
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    Quote Originally Posted by daffodil11 View Post
    Use the word cursive instead. Outlook will know what you mean.

    Please Login or Register  to view this content.
    That worked.. I updated cursive and the font was comic sans ms in the mail ..

    But what should I do if I want to change to other multiple word fonts..
    Please guide me..

  17. #17
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: HTML code for colors

    Double quote around the words. Outlook doesn't understand Comic Sans MS, but if it did it would look like this:

    Please Login or Register  to view this content.

  18. #18
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    Quote Originally Posted by daffodil11 View Post
    Double quote around the words. Outlook doesn't understand Comic Sans MS, but if it did it would look like this:

    Please Login or Register  to view this content.
    Thanks for your reply.... Double quote doesn't work .. i already tried that.. The problem is that with or without quotes when i try to update the font with two or more words, only the first word of the font is displayed in the font section of the outlook..

    For example when i try to update with comic sans ms, only comic is displayed in outlook..

  19. #19
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: HTML code for colors

    That's why you use cursive instead. Outlook doesn't key Comic Sans MS as "Comic Sans MS". You'll have to look up specifically what tags are related to each font.

    Do you have another font in mind?

  20. #20
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    Quote Originally Posted by daffodil11 View Post
    That's why you use cursive instead. Outlook doesn't key Comic Sans MS as "Comic Sans MS". You'll have to look up specifically what tags are related to each font.

    Do you have another font in mind?
    Cursive is perfectly working fine for me .. i don't need for any other font now.. if you can advise me where to look for tags for other fonts, it may definitely help me in future..

  21. #21
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: HTML code for colors

    I posted two links in my first post. Other than that, just Google "HTML font-family <insert name of font>"

  22. #22
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    155

    Re: HTML code for colors

    Quote Originally Posted by daffodil11 View Post
    I posted two links in my first post. Other than that, just Google "HTML font-family <insert name of font>"
    Fantastic.. That will help.. Thanks a lot for your help and support ..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using VBA in html code
    By souljive99 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-05-2009, 11:34 AM
  2. Cell with HTML Code
    By Bnkeane in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-23-2008, 10:31 AM
  3. ADD HTML CODE
    By Tweedy in forum Excel General
    Replies: 1
    Last Post: 01-14-2006, 06:10 PM
  4. Flashing colors in HTML output?
    By John Oliver in forum Excel General
    Replies: 0
    Last Post: 11-27-2005, 06:50 PM
  5. [SOLVED] HTML Code cleaner
    By heren in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-14-2005, 03:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1