link

geebee · Jan 12, 2010

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>" _
& emailTITLE & " " _
& "" _
& BDY2 & "" _
& "" _
& "" _
& BDY3 & "" _
& " " _
& BDY4 & "" _
& " " _
& BDY5 & "" _
& " " _
& BDY6 & "" _
....

thanks in advance,
geebee

joel · Jan 12, 2010

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

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

So it should be this

l_Msg.HTMLBody = "<html>" _
& emailTITLE & " " _
& "" _
& BDY2 & "" _
& "" _
& "" _
& BDY3 & "" _
& " " _
& BDY4 & "" _
& " 
_
& BDY5 & "" _
& " " _
& BDY6 & "" _
& "<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 actua
double quote will appear in the results

revise to not include attchmnt	1	Dec 10, 2009
no attachment	0	Dec 10, 2009
e-mail issue	1	Mar 19, 2010
find string in web page	3	Dec 7, 2007
Problem seeing some characters when sending email to Outlook client	60	Oct 15, 2010
Fails then continues without error	6	Sep 20, 2008
Receiving code instead of graphics	0	Dec 26, 2009
Can one include data from javascript in form	1	Dec 30, 2009

link

geebee

joel

Ask a Question

Similar Threads