+ Reply to Thread
Results 1 to 5 of 5

How to change colour code on HTML.BODY for outlook emails

  1. #1
    Registered User
    Join Date
    05-17-2018
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    24

    How to change colour code on HTML.BODY for outlook emails

    Hello,
    Please see below my email body using html.


    .HTMLbody = "Hi Customers," & "<br>" & "<br>" & _
    "Attached is your statement." & "<br>" & "<br>" & _
    "[email protected]"


    I need "Hi Customer" in colour code Aqua R0 G255 B255
    And "Attached is your statement" in colour Blue R0 G30 B205

    ALSO my email address is coming as text, how do I change it to email link?

    Thankyou!

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: How to change colour code on HTML.BODY for outlook emails

    Body as its name states contain html, so I assume that something like:
    HTML Code: 
    HTML Code: 
    should do the job.

    The same about link of your email, it should be something like:

    HTML Code: 
    Last edited by KOKOSEK; 05-23-2019 at 09:08 AM.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    05-17-2018
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    24

    Re: How to change colour code on HTML.BODY for outlook emails

    Should code look like this?

    .HTMLbody = < font color="#00FFFF">"Hi Customers," </font> & "<br>" & "<br>" & _
    < font color="#001ECD">"Attached is your statement."</font> & "<br>" & "<br>" & _
    <a href="mailto:[email protected]">[email protected]</a>

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: How to change colour code on HTML.BODY for outlook emails

    almost. Be careful with "" when you opening/closing.
    (delete space between < and font, I've put it because firewall does not allow me to post it without additional space even if I've marked it as html code)
    try like this:

    (for some reason even wrapping in htmlcode tags does not allow me to post, so on picture)

    Capture.JPG
    Last edited by KOKOSEK; 05-23-2019 at 09:41 AM.

  5. #5
    Registered User
    Join Date
    05-17-2018
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    24

    Re: How to change colour code on HTML.BODY for outlook emails

    Thank you. But the email is coming up a link, its asking me to Ctrl click to activate. I need to check and open new message.
    How do I fix this?

+ 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. Export Outlook Folder Emails to excel -- need body separated
    By BG1983 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 07-04-2017, 02:11 PM
  2. Replies: 0
    Last Post: 09-07-2015, 04:05 PM
  3. [SOLVED] Vba to draft html body in outlook
    By arun.sj in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-15-2015, 07:37 AM
  4. Replies: 0
    Last Post: 04-24-2015, 09:44 AM
  5. Excel ws into outlook html body with current html signature
    By Cadelanne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 09:03 AM
  6. Import body of multiple Outlook emails into Excel workbook
    By Ticklekisses in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2013, 04:25 PM
  7. [SOLVED] Sending emails in outlook body
    By vijanand1279 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-31-2012, 03:34 PM

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