Change font, size, color for email body

J

john55

New Member
Joined
Oct 31, 2010
Messages
26
hello!
I use this code for email and I want to have different font text, size and color for it.
I appreciate your help!
Rich (BB code): 
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
 
Last edited:

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
You would need to use HTML tags for that.

What do you have at the moment in HTMLCode?
 
Upvote 0
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
 
Upvote 0
hi Andrew,
I can not edit the first post anymore,
HTML: 
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! :)
 
Last edited:
Upvote 0
John

If you want to post HTML wrap it in
HTML:
tags.
 
Upvote 0
Solved.
HTML: 
"<br/>" & "<br/>" & "<br/>" & "<font face=""Courier New"" size=""2"" color=""blue"">" & "This text font Courier New, size 2, color blue..or whatever" 
'
'
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Macro to open a new email via Outlook
Replies
3
Views
285
skillilea
S
F
  • Solved
How to add text to e-mail body when checkbox is ticked on userform
Replies
2
Views
345
flea80
F
G
  • Question
Excel VBA to reply to existing email chain and add workbook as attachment
Replies
4
Views
220
gopalgriffith
G
B
  • Solved
Change existing code to attach range of cells to email
Replies
2
Views
224
bh24524
B
J
  • Solved
Email body not showing using html.
Replies
3
Views
598
Logit
Logit

Forum statistics

Threads
1,215,110
Messages
6,123,147
Members
449,098
Latest member
Doanvanhieu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top