ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Display BOLD and Colored text in outlook body (https://www.excelbanter.com/excel-programming/435698-re-display-bold-colored-text-outlook-body.html)

Ron de Bruin

Display BOLD and Colored text in outlook body
 
Use htmlbody

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"


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" wrote in message ...
How can I display Bold text and Colored text in Outlook body when I am
sending email through excel?

Thanks in advance


Ron de Bruin

Display BOLD and Colored text in outlook body
 
Oops

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


--

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


"Ron de Bruin" wrote in message ...
Use htmlbody

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"


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" wrote in message ...
How can I display Bold text and Colored text in Outlook body when I am
sending email through excel?

Thanks in advance



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com