Using HTML Body Format in Outlook mail

Hi All,

I have a Macro which send out the Mail using Outlook.
Issue i am facing here is
1) How to send a Formatted Email For example: BOLD, Font Colour in Email.
2) How to add my deafult signature in the mail.

I have limited understnding about Macro and have build this Macro using Different Source.

Please help.


Below is my Code.

Please Login or Register  to view this content.

Thank you
Akash

Hi Sakmsb,
Thank you for responce
I have looked into Ron website but not sure what to do with this. I am using Sheet Named "Mailing List" in which under Cell I3 i have put the mailBody as below. is this some i have to update within I3 cell ? I have to format few words in the body as well (Coloured and Bold)

strbody = "<H3><B>Dear Customer Ron de Bruin</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/tips.htm"">Ron's Excel Page</A>" & _
"<br><br><B>Thank you</B>"


Hi All,

Please can you provide your metrics data for last month

My outlook Singature


Akash