How do I implement an email link in this loop?
Right where the email address is displayed, I just can't figure out how to add the link.
SHADE = 0
do while not rs.EOF
if SHADE = 1 then
Response.Write "<tr bgcolor=#C0C0FF>" & "<td>" & rs("name" & "</td>" & "<td>" & rs("phone" & "</td>" & "<td>" & rs("cell" & "</td>" & "<td>" & rs("email" & "</td>" & "</tr>"
SHADE = 0
else
Response.Write "<tr bgcolor=#FFFF80>" & "<td>" & rs("name" & "</td>" & "<td>" & rs("phone" & "</td>" & "<td>" & rs("cell" & "</td>" & "<td>" & rs("email" & "</td>" & "</tr>"
SHADE = 1
end if
Right where the email address is displayed, I just can't figure out how to add the link.
SHADE = 0
do while not rs.EOF
if SHADE = 1 then
Response.Write "<tr bgcolor=#C0C0FF>" & "<td>" & rs("name" & "</td>" & "<td>" & rs("phone" & "</td>" & "<td>" & rs("cell" & "</td>" & "<td>" & rs("email" & "</td>" & "</tr>"
SHADE = 0
else
Response.Write "<tr bgcolor=#FFFF80>" & "<td>" & rs("name" & "</td>" & "<td>" & rs("phone" & "</td>" & "<td>" & rs("cell" & "</td>" & "<td>" & rs("email" & "</td>" & "</tr>"
SHADE = 1
end if