Is it possible to format an e-mail after it has been created with VB in excel?
I want to make part of the text Red. is it also possible to change the font?

To format an email you need to use the "HTMLBody" Property.

--
HTH

Bob Phillips

"Chris" wrote in message
...
Is it possible to format an e-mail after it has been created with VB in
excel?
I want to make part of the text Red. is it also possible to change the
font?

Hi Chris

You must use the HTMLBody then instead if Body

Why don't you create it on a worksheet and send it the way it is
http://www.rondebruin.nl/mail/folder3/mail2.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Chris" wrote in message ...
Is it possible to format an e-mail after it has been created with VB in excel?
I want to make part of the text Red. is it also possible to change the font?

Thanks, but i've never used HTMLBody?

"Bob Phillips" wrote:

To format an email you need to use the "HTMLBody" Property.

--
HTH

Bob Phillips

"Chris" wrote in message
...
Is it possible to format an e-mail after it has been created with VB in
excel?
I want to make part of the text Red. is it also possible to change the
font?

Chris

It isn't difficult to use HTMLBody.

Code:
--------------------

Dim myOlapp As New Outlook.Application
Dim myOLItem As Outlook.MailItem
Dim myVar As Integer

Set myOLItem = myOlapp.CreateItem(olMailItem)
myVar = 12
With myOLItem
.Subject = "Some Subject"
.HTMLBody = "<pYour score was <b" & myVar & "</b</p"
.HTMLBody = .HTMLBody & "<pNext line</p"
.To = "
.Display
End With
--------------------


--
Norie
------------------------------------------------------------------------
Norie's Profile: http://www.excelforum.com/member.php...o&userid=19362
View this thread: http://www.excelforum.com/showthread...hreadid=378405

Then you can also use some formatting tags such as bold and font.

--
HTH

Bob Phillips

"Norie" wrote in
message ...

Chris

It isn't difficult to use HTMLBody.

Code:
--------------------

Dim myOlapp As New Outlook.Application
Dim myOLItem As Outlook.MailItem
Dim myVar As Integer

Set myOLItem = myOlapp.CreateItem(olMailItem)
myVar = 12
With myOLItem
.Subject = "Some Subject"
.HTMLBody = "<pYour score was <b" & myVar & "</b</p"
.HTMLBody = .HTMLBody & "<pNext line</p"
.To = "
.Display
End With
--------------------


--
Norie
------------------------------------------------------------------------
Norie's Profile:
http://www.excelforum.com/member.php...o&userid=19362
View this thread: http://www.excelforum.com/showthread...hreadid=378405