How to use href for email address pulled from database

[Jack]

Hi, I have the following code which displays email address from a database
However, I need to have the email address highlighted so that on clicking
the email box would open up with the email name filled in. Any thoughts or
help is appreciated.
Thanks.

CODE:

If Not IsNull(Recordset1("PeopletEmailAddress")) then Response.Write
Recordset1.Fields("PeopletEmailAddress")
Response.Write "</TD>"

 

[Ray Costanzo [MVP]]

How would you do it if it where just a static html page you were writing?

<a href="mailto:[email protected]">[email protected]</a>


So, how about

If Not IsNull(Recordset1("PeopletEmailAddress")) then
Response.Write "<a href=""mailto:" &
Recordset1.Fields("PeopletEmailAddress") & """>" &
Recordset1.Fields("PeopletEmailAddress") & "</a>"
Response.write "</td>"
End if

Ray at work