------ Register to get rid of these "In Post" ads! ------


HI,
I modified Ron De Bruin code for "SmallMessage" in a project I'm
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-vba-programming/135905-outlook-body-text-bold.html#post493155
working on.
Is there a way to have the message text displayed as bold when the
message is sent?

------ Register to get rid of these "In Post" ads! ------


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><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>" & _
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-vba-programming/135905-outlook-body-text-bold.html#post493163
"<br><br><B>Thank 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" <harm.charles@gmail.com> wrote in message news:5223cd59-4cd5-47be-ad3b-87460777137d@g6g2000vbr.googlegroups.com...
> 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?
>

------ Register to get rid of these "In Post" ads! ------


On Sep 17, 2:40*pm, "Ron de Bruin" <rondebr...@kabelfoon.nl> wrote:
> 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><B>Dear Customer</B></H3>" & _
> * * * * * * * "Please visit this website to download the new version.<br>" & _
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-vba-programming/135905-outlook-body-text-bold.html#post493193
> * * * * * * * "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>"
>
> Use .HTMLBody = strbody then instead of .Body = strbody
>
> If you want to send a range or worksheet as HTML see this two examples.
>
> Range/Selectionhttp://www.rondebruin.nl/mail/folder3/mail4.htm
>
> Whole worksheethttp://www.rondebruin.nl/mail/folder3/mail2.htm
>
> --
>
> Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
> "Charles" <harm.char...@gmail.com> wrote in messagenews:5223cd59-4cd5-47be-ad3b-87460777137d@g6g2000vbr.googlegroups.com...
> > 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?

Thanks Ron for your replay and thanks for you site. It was a great
help to me.