Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-Mailing macro font options
I am using a macro to send e-mails through Excel. If for example, I want one
word or the whole line to be bold in the e-mail, how would I do this? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-Mailing macro font options
See
http://www.rondebruin.nl/mail/tips2.htm 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 more HTML tags examples. <B = bold 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "G and (ajk)" wrote in message ... I am using a macro to send e-mails through Excel. If for example, I want one word or the whole line to be bold in the e-mail, how would I do this? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to import my Excel Mailing list into mailing label format. | Excel Discussion (Misc queries) | |||
I need to import my Excel Mailing list into mailing label format. | Excel Discussion (Misc queries) | |||
How do I increase the font of my drop-down menu options? | Excel Worksheet Functions | |||
How do I get all the options in the Format tab? I only get font op | Excel Worksheet Functions | |||
EXCEL Workbook tab format options: change color or font | Excel Discussion (Misc queries) |