Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Send a Sheet as body of Outlook Email | Excel Discussion (Misc queries) | |||
HELP!.. copy Bitmap of range from Excel to Outlook body | Excel Programming | |||
Outlook email url in body | Excel Programming | |||
Late Binding to Outlook from Excel: Outlook modifies email body | Excel Programming | |||
Controlling the position of attachments and Body Text in Outlook | Excel Programming |