Change font, size, color for email body

[john55]

hello!
I use this code for email and I want to have different font text, size and color for it.
I appreciate your help!

Set olEmail = olApp.CreateItem(olMailItem)
With olEmail
.To = ""
.cc = ""
.Subject = "" & "-" & Format(Now, "dd_mmmm_yyyy")
.BodyFormat = olFormatHTML
.HTMLBody = "test for" & " " & Format(Now, "dd mmmm yyyy") & _
"" & "Brgds," & "" & "me" & "" & "" & "" & "This text font Courier New, size 11" & _
"" & "" & "" & "This text font Courier New, bold, color blue, size 11" & _
"" & "e-mail: aaa@bbb.com" & "" & "Website: www.gggg.com"
.display
End With
'With Sheet2

regards
j

 

[Norie]

You would need to use HTML tags for that.

What do you have at the moment in HTMLCode?

 

[john55]

hi Norie,
thanks, as you saw I tried to add code tags but ...well, that's it! hope you can see what I want to say...

j

 

[Andrew Poulsom]

You'll have to use HTML code for that, but I'm no expert so I can't tell you what it is. You could also try formatting it in Excel and using the code here to add it to the EMail body.:

http://www.rondebruin.nl/mail/folder3/mail4.htm

 

[john55]

hi Andrew,
I can not edit the first post anymore,

Set olEmail = olApp.CreateItem(olMailItem)
            With olEmail
              .To = ""
              .cc = ""
              .Subject = "" & "-" & Format(Now, "dd_mmmm_yyyy")
              .BodyFormat = olFormatHTML
                .HTMLBody = "test for" & " " & Format(Now, "dd mmmm yyyy") & _
                "<br/>" & "Brgds," & "<br/>" & "me" & _
                "<br/>" & "<br/>" & "<br/>" & "This text font Courier New, size 11" & _
                "<br/>" & "<br/>" & "<br/>" & "This text font Courier New, bold, color blue, size 11" & _
                "<br/>" & "e-mail: aaa@bbb.com" & "<br/>" & "Website: www.gggg.com"
              .display
              End With
            'With Sheet2

thank you Norie, I followed the link from yr signature!

 

[Norie]

John

If you want to post HTML wrap it in

tags.

 

[john55]

Solved.

"<br/>" & "<br/>" & "<br/>" & "<font face=""Courier New"" size=""2"" color=""blue"">" & "This text font Courier New, size 2, color blue..or whatever" 
'
'