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:15179EDC-C739-42BA-A5D2-(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

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:15179EDC-C739-42BA-A5D2-(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