none
Set Background Color of HTML Email Message Lines RRS feed

  • Question

  • I am writing to ask it the background color can be set in the HTMLBody of a email message - sent from Visual Basic for Applications;

    Please see below for code sample - thanks in advance for any insight;

    .HTMLBody = "<br>Top Parent Account: " & Cells(cell.Row, "M").Value _
                          & vbNewLine & vbNewLine & _
                          "<br>Account Owner: " & Cells(cell.Row, "N").Value _
                          & vbNewLine & vbNewLine & _
                          "<br>Segment: " & Cells(cell.Row, "O").Value _
                          & vbNewLine & vbNewLine & _
                          "<br>Opportunity ID: " & Cells(cell.Row, "D").Value _
                          & vbNewLine & vbNewLine & _
                          "<br>Opportunity Name: " & Cells(cell.Row, "P").Value _
                          & vbNewLine & vbNewLine & _
                          "<br>Opportunity Owner: " & Cells(cell.Row, "Q").Value _
                          & vbNewLine & vbNewLine & _
                          "<br>Sales Stage: " & Cells(cell.Row, "R").Value _
                          & vbNewLine & vbNewLine & _
                          "<br>Link: " & Cells(cell.Row, "S").Value _
                          .Send  


    robert hellestrae


    Tuesday, May 14, 2013 2:27 PM

Answers