link
 

hi,

i have the following to put something into an email body. trying to figure
out how to put an <a href link in it also..

.....
l_Msg.HTMLBody = "<html<p<font size=""1"" color=""999999"" face =
""arial""<b<u" _
& emailTITLE & "</u</b</font<br" _
& "<font size=""1"" color=""336699"" face = ""arial""" _
& BDY2 & "</font" _
& "</p" _
& "<font size=""1"" color=""999999"" face = ""arial""<b<u" _
& BDY3 & "</u</b</font" _
& "<br<font size=""1"" color=""336699"" face = ""arial""" _
& BDY4 & "</font" _
& "<br<br<font size=""1"" color=""999999"" face = ""arial""<b<u" _
& BDY5 & "</u</b</font" _
& "<br<font size=""1"" color=""336699"" face = ""arial""" _
& BDY6 & "</font" _
....

thanks in advance,
geebee

link
 

I opened a new Word document and copied an IE address from my web
browser into the word document and then saved word as HTML. I then
extracted this line:

<p class=MsoNormal<a
href="http://www.thecodecage.com/forumz/excel-vba-programming/169100-link.html"http://www.thecodecage.com/forumz/excel-vba-programming/169100-link.html</a</p

So it should be this

l_Msg.HTMLBody = "<html<p<font size=""1"" color=""999999"" face =
""arial""<b<u" _
& emailTITLE & "</u</b</font<br" _
& "<font size=""1"" color=""336699"" face = ""arial""" _
& BDY2 & "</font" _
& "</p" _
& "<font size=""1"" color=""999999"" face = ""arial""<b<u" _
& BDY3 & "</u</b</font" _
& "<br<font size=""1"" color=""336699"" face = ""arial""" _
& BDY4 & "</font" _
& "<br<br<font size=""1"" color=""999999"" face = ""arial""<b<u"
_
& BDY5 & "</u</b</font" _
& "<br<font size=""1"" color=""336699"" face = ""arial""" _
& BDY6 & "</font" _
& "<a href=""http://www.thecodecage.com/forumz/" _
& "excel-vba-programming/169100-link.html""" _
& "http://www.thecodecage.com/forumz/" _
& "excel-vba-programming/169100-link.html</a"


Note I put two double quotes in a row into the string so the actual
double quote will appear in the results.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=169100

Microsoft Office Help