Change Font formatting mid-sentence of HTMLBody Outlook mail

**askpcguy** · 07-31-2014, 05:16 PM

Originally Posted by Domenic

Try replacing...

.HTMLBody = "<HTML><BODY><H2><I><P Style='font-family:Arial;font-size:18pt;color:red'>Example <Change font color HERE>Text #1</CHANGE></I></H2></P>"

with

.htmlbody = "<HTML><BODY><H2><I><P Style='font-family:Arial;font-size:18pt;color:red'>Example <span style=""color:rgb(31,73,125);"">Text #1</span></P></I></H2>"

That did the trick! Here's my final code. Now I've got to find a way to add some space between the table columns. I'd think by now I owe someone a lunch!!!

    .HTMLBody = "<HTML><BODY><H2><I><P Style='font-family:Arial;font-size:18pt;color:red'>New Alert"
    .HTMLBody = .HTMLBody & "<Span Style=""Color:RGB(31,73,125);"">TextColor2-On-Same-Line!!!!</SPAN></P></I></H2>"
    .HTMLBody = .HTMLBody & "<TABLE><TR><TD><B>Incident Report Detail:</TD></B><a href=""" & MyLink & _
        TextBox1.Value & """>" & TextBox1.Value & "</a>" & _
        "<TR><TD><B>Status:</TD></TR></B>" & ComboBox1.Text & _
        "<TR><TD><B>Date/Time Reported:</TD></TR></B>" & TextBox2.Text & _
        "<TR><TD><B>Impact Summary:</TD></TR></B>" & TextBox3.Text & _
        "<TR><TD><B>Locations Impacted:</TD></TR></B>" & TextBox4.Text & _
        "<TR><TD><B>Incident Manager:</TD></TR></B>" & TextBox5.Text & _
        "<TR><TD><B>Actions / Progress:</TD></TR></B>" & TextBox6.Text & _
        "<TR><TD><B>Root Cause:</TD></TR></B>" & TextBox7.Text & _
        "</TABLE></BODY></HTML>"
    .Importance = 2

**Domenic** · 07-31-2014, 07:07 PM

It doesn't look that your code actually creates a table consisting of two columns, which is what I think you want. Try to adopt the following code, which creates a table consisting of 2 rows and 2 columns...

.HTMLBody = "<table style=""text-align: left;"" border=""0""" & _
             "cellpadding=""2"" cellspacing=""2"">" & _
              "<tbody>" & _
                "<tr>" & _
                  "<td style=""font-weight: bold; width: 300px;"">Incident Report Detail:</td>" & _
                  "<td style=""width: 300px;""><a href=""www.google.com"">MyLink</a></td>" & _
                "</tr>" & _
                "<tr>" & _
                  "<td><span style=""font-weight: bold;"">Status:</span></td>" & _
                  "<td>Text here...</td>" & _
                "</tr>" & _
              "</tbody>" & _
            "</table>"

Notice that the each <tr>...</tr> refers to one row, and each <td>...</td> refers to one column. Adjust the widths for each column, accordingly. And, you may want to adjust the cellpading and cellspacing.

Hope this helps!

**askpcguy** · 07-31-2014, 07:58 PM

Thank you Domenic, working on this now. Is there a tag to allow a table cell to word wrap? Or would that happen on its own?

**Domenic** · 07-31-2014, 08:27 PM

Unless otherwise specified, I think it would happen on it's own...

**askpcguy** · 07-31-2014, 08:58 PM

Cool beans, I could use a break! I'm slowly adding your new table layout into the VBA and its working.

Change Font formatting mid-sentence of HTMLBody Outlook mail

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Change Font formatting mid-sentence of HTMLBody Outlook mail

Re: Change Font formatting mid-sentence of HTMLBody Outlook mail

Re: Change Font formatting mid-sentence of HTMLBody Outlook mail

Re: Change Font formatting mid-sentence of HTMLBody Outlook mail

Re: Change Font formatting mid-sentence of HTMLBody Outlook mail

Thread Information

Users Browsing this Thread

Similar Threads

Change font size of text in mail VBA code

Change of formatting in a sentence to subscript

Change of formatting in a sentence to subscript

change e-mail font default color

[SOLVED] outlook htmlbody

Bookmarks

Bookmarks

Posting Permissions