Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |