Thread: Mail Body
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Mail Body

With HTMLBody this is possible

From
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.

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


"Amol" wrote in message oups.com...
Is it possible to format text size,color and type of the font


On Aug 5, 12:45 am, "Ron de Bruin" wrote:
Hi Amol

For example see this pagehttp://www.rondebruin.nl/mail/folder3/smallmessage.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Amol" wrote in oglegroups.com...
HI


Please guide me abt adding text in next line in mail body of macro


I want to send mails through macro where i put some code in macro


like .body = "Dear All"


Now i want "regards" on next line


thanxs- Hide quoted text -


- Show quoted text -