View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Outlook Body Text to Bold

Hi Charles

Formatted text (HTML)

If you want to create emails that are formatted you can use HTMLBody (Office 2000 and up) instead of Body.
You can find a lot of WebPages on the internet with HTML tags examples.

strbody = "<H3<BDear Customer</B</H3" & _
"Please visit this website to download the new version.<br" & _
"Let me know if you have problems.<br" & _
"<A HREF=""http://www.rondebruin.nl/""Ron's Excel Page</A" & _
"<br<br<BThank you</B"

Use .HTMLBody = strbody then instead of .Body = strbody

If you want to send a range or worksheet as HTML see this two examples.

Range/Selection
http://www.rondebruin.nl/mail/folder3/mail4.htm

Whole worksheet
http://www.rondebruin.nl/mail/folder3/mail2.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Charles" wrote in message ...
HI,
I modified Ron De Bruin code for "SmallMessage" in a project I'm
working on.
Is there a way to have the message text displayed as bold when the
message is sent?