Formatting e-mails after creation
 

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?

Formatting e-mails after creation
 

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?

Formatting e-mails after creation
 

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?

Formatting e-mails after creation
 

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?

Formatting e-mails after creation
 

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

Formatting e-mails after creation
 

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