Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Outlook Body Text to Bold

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?

  #2   Report Post  
Posted to microsoft.public.excel.programming
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?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Outlook Body Text to Bold

On Sep 17, 2:40*pm, "Ron de Bruin" 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<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/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" wrote in ...
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send a Sheet as body of Outlook Email David Ackerman on cape cod Excel Discussion (Misc queries) 0 March 19th 10 03:11 PM
HELP!.. copy Bitmap of range from Excel to Outlook body WhytheQ Excel Programming 1 October 17th 07 11:53 AM
Outlook email url in body kevinho[_3_] Excel Programming 2 August 26th 05 12:48 PM
Late Binding to Outlook from Excel: Outlook modifies email body Lenny Wintfeld Excel Programming 0 December 12th 04 04:03 PM
Controlling the position of attachments and Body Text in Outlook Richard Buttrey[_4_] Excel Programming 1 November 4th 03 08:27 PM


All times are GMT +1. The time now is 07:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"