View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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