Font Colour Query

Chris Williamson

Board Regular
Joined
Oct 16, 2010
Messages
83
Hi Guys,

I've got a little query here regarding font colour...

This code opens a new email message, the font colour in the body of the email mesage is all black.

What I would like is the last three lines "Text Line 3, 4 and 5" to be in a different colour... eg Gray rather than Black.

How do you do that?


Code:
[SIZE=3][FONT=Arial]Set olApp = CreateObject("Outlook.Application")<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Arial]Set newmessage = olApp.CreateItem(0)<o:p></o:p>[/FONT][/SIZE]
<o:p></o:p>
[SIZE=3][FONT=Arial]newmessage.SentOnBehalfOfName = Worksheets("Sheet1").Range("A1").Value<o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Arial]newmessage.To = Worksheets("Sheet1").Range("A2").Value<o:p></o:p>[/FONT][/SIZE]
<o:p></o:p>
[SIZE=3][FONT=Arial]newmessage.body = "Dear Sir/Madam," & Chr(13) & Chr(13) _<o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Arial]& "Text Line 1" & Chr(13) & Chr(13) _<o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Arial]& "Text Line 2" & Chr(13) & Chr(13) & Chr(13) _<o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Arial]& "Text Line 3" & Chr(13) _<o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Arial]& "Text Line 4" & Chr(13) _<o:p></o:p>[/FONT][/SIZE]
[FONT=Arial][SIZE=3]& "Text Line 5"[/SIZE][/FONT]
<o:p></o:p>
[SIZE=3][FONT=Arial]newmessage.Display<o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Arial]Set olApp = Nothing<o:p></o:p>[/FONT][/SIZE]
[FONT=Arial][SIZE=3]Set newmessage = Nothing[/SIZE][/FONT]
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Forum statistics

Threads
1,224,552
Messages
6,179,488
Members
452,917
Latest member
MrsMSalt

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