Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Coma between two e-mails | Excel Discussion (Misc queries) | |||
Finding e-mails | Excel Worksheet Functions | |||
Opening e-mails | Excel Discussion (Misc queries) | |||
send e-mails | Excel Discussion (Misc queries) | |||
e-mails addresses | Excel Worksheet Functions |