EMAIL BODY IN HTML FORMAT - Lotus Notes

[Ravisca2003]

Hi Experts,
Seek your help here for improving the code below to send HTML Format Mail Body.

I have somehow written a code which can pull some 6 lines in the mail body with line breaks . I wanted to have a code which could send color, bold , italic messages as I have to often use Bold and italic to highlight deadlines but this code just try to publish text. I dont know how to invoke a HTML message and second even if I invoke a HTML message, I will be typing the same in excel workbook so want that if I type something in BOLD or ITALIC or UNDERLINE or Color, it should be refected the same way. Can I get some mentors here to show me the right path to achieve this.

Thanks in advance.

Also the code may be crude but work so if any value add is suggested to improvise the same and do it a more appropriate way, I will be really looking towards it.

Thanks again !!!!

Please Login or Register  to view this content.

[LJMetzger]

Hi

The code and file associated with post #9 in the following thread may help you: https://www.excelforum.com/office-36...ml#post4773862

Note that in your code you use a Text Body:

Please Login or Register  to view this content.

An HTML Body is Required to add font attributes (in addition to replacing Carriage Return and/or Linefeed with '<BR>'):

Please Login or Register  to view this content.

The following code excerpt contains sample code to control some font attributes of .HTMLBbody

Please Login or Register  to view this content.

Please note that the ExcelForum Firewall does not permit HTML code. If you use the above code replace all qqq with <.


To add a signature to your code see the code below that is contained in the file associated with post #9 in the following thread: http://www.excelforum.com/excel-prog...mail-body.html

Please Login or Register  to view this content.

I hope this helps.

Lewis