I was wondering how I could format a text in an e-mail that was
generated by excel. Basically I would need to know what the command is
to go to line and how to bold and underline a word. If anybody knows
how to do this that would be of great help! Thanks again


--
JBCIB
------------------------------------------------------------------------
JBCIB's Profile: http://www.excelforum.com/member.php...o&userid=33794
View this thread: http://www.excelforum.com/showthread...hreadid=538873

I'd be interested in this as well. I did something similar a few weeks
ago. For a formatted a Word document then saved it in HTML format. In
the VBA code instead of using .Body and attaching a text file, I used
..HTMLBody and it worked great.

- John

See the body examples
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"JBCIB" wrote in message
...

I was wondering how I could format a text in an e-mail that was
generated by excel. Basically I would need to know what the command is
to go to line and how to bold and underline a word. If anybody knows
how to do this that would be of great help! Thanks again


--
JBCIB
------------------------------------------------------------------------
JBCIB's Profile: http://www.excelforum.com/member.php...o&userid=33794
View this thread: http://www.excelforum.com/showthread...hreadid=538873

I might have missed but I cheked your link and the info I am looking wa
not there. I have a macro that generates the e-mail and numbe
formatting that i want. Iam now missing code defining how to bold an
underline 2 wrods in my e-mail. Thanks for the link though there wa
some good info there!:

--
JBCI
-----------------------------------------------------------------------
JBCIB's Profile: http://www.excelforum.com/member.php...fo&userid=3379
View this thread: http://www.excelforum.com/showthread.php?threadid=53887

If You create html in the macro then try

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"



--
Regards Ron de Bruin
http://www.rondebruin.nl


"JBCIB" wrote in message
...

I might have missed but I cheked your link and the info I am looking was
not there. I have a macro that generates the e-mail and number
formatting that i want. Iam now missing code defining how to bold and
underline 2 wrods in my e-mail. Thanks for the link though there was
some good info there!:)


--
JBCIB
------------------------------------------------------------------------
JBCIB's Profile: http://www.excelforum.com/member.php...o&userid=33794
View this thread: http://www.excelforum.com/showthread...hreadid=538873