+ Reply to Thread
Results 1 to 22 of 22

HTML code for colors

Hybrid View

arun.sj HTML code for colors 07-10-2015, 04:17 PM
daffodil11 Re: HTML code for colors 07-10-2015, 04:50 PM
arun.sj Re: HTML code for colors 07-11-2015, 03:14 PM
arun.sj Re: HTML code for colors 07-13-2015, 03:42 AM
daffodil11 Re: HTML code for colors 07-13-2015, 09:17 AM
daffodil11 Re: HTML code for colors 07-13-2015, 09:09 AM
arun.sj Re: HTML code for colors 07-14-2015, 03:55 AM
arun.sj Re: HTML code for colors 07-14-2015, 03:59 AM
arun.sj Re: HTML code for colors 07-15-2015, 02:29 AM
LordLoki Re: HTML code for colors 07-15-2015, 05:29 AM
arun.sj Re: HTML code for colors 07-15-2015, 07:45 AM
arun.sj Re: HTML code for colors 07-16-2015, 02:17 AM
arun.sj Re: HTML code for colors 07-16-2015, 02:19 AM
arun.sj Re: HTML code for colors 07-16-2015, 07:51 AM
daffodil11 Re: HTML code for colors 07-16-2015, 10:13 AM
arun.sj Re: HTML code for colors 07-16-2015, 10:54 AM
daffodil11 Re: HTML code for colors 07-16-2015, 11:14 AM
arun.sj Re: HTML code for colors 07-16-2015, 01:18 PM
daffodil11 Re: HTML code for colors 07-16-2015, 01:28 PM
arun.sj Re: HTML code for colors 07-16-2015, 02:14 PM
daffodil11 Re: HTML code for colors 07-16-2015, 02:16 PM
arun.sj Re: HTML code for colors 07-16-2015, 02:34 PM
  1. #1
    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..

  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

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

    Sub Fluffypuff()
    
    Dim OutApp As Object
    Dim OutMail As Object
    Dim strBody As String
    Dim strOpener As String
    
    Signature = "<font color=002395><b>Captain Bananas <br>" & _
                "</b></font>"
    
    
    strCloser = "I am somewhat nifty."
    
        
    strBody = "<font face=""Arial""> Bob,<br><br><br>" & strOpener & _
                        strCloser & "<br><br>Thanks,<br>" & Signature
               
            
            
            Set OutApp = CreateObject("Outlook.Application")
            Set OutMail = OutApp.CreateItem(0)
            
                With OutMail
                    .to = "themuffinman@drearylane"
                    .Subject = "Do you know the muffin man?"
                    .HTMLbody = strBody
                    .Display
                End With
            
            Set OutApp = Nothing
            Set OutMail = Nothing
        
    
    End Sub
    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!

+ 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. [SOLVED] 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. 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