PC Review


Reply
Thread Tools Rate Thread

Re: Display BOLD and Colored text in outlook body

 
 
Ron de Bruin
Guest
Posts: n/a
 
      2nd Nov 2009
Use htmlbody

strbody = "<H3><B>Dear 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><B>Thank you</B>"


For a range or sheet see
http://www.rondebruin.nl/mail/folder3/mail4.htm



--

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


"sam" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> How can I display Bold text and Colored text in Outlook body when I am
> sending email through excel?
>
> Thanks in advance

 
Reply With Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      2nd Nov 2009
Oops

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


--

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


"Ron de Bruin" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Use htmlbody
>
> strbody = "<H3><B>Dear 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><B>Thank you</B>"
>
>
> For a range or sheet see
> http://www.rondebruin.nl/mail/folder3/mail4.htm
>
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "sam" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>> How can I display Bold text and Colored text in Outlook body when I am
>> sending email through excel?
>>
>> Thanks in advance

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display BOLD and Colored text in outlook body sam Microsoft Excel Programming 1 2nd Nov 2009 11:23 PM
How to programaticaly use Bold or Colored Text in Task Body bbnimda Microsoft Outlook Form Programming 12 7th Nov 2008 03:08 PM
Using Outlook 2002/Word 2002 - Mail Merge - need text in the message with bold, underlines, and colored text,..need it to look pretty =?Utf-8?B?Um96enp6?= Microsoft Outlook 0 17th Feb 2004 03:51 PM
Cell right next to colored cells is automatically colored on entering a value Johan De Schutter Microsoft Excel Misc 6 12th Sep 2003 05:31 PM
Cell right next to colored cells is automatically colored on entering a value Johan De Schutter Microsoft Excel Programming 6 12th Sep 2003 05:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:47 AM.