email to link

[Chas]

I am using this code

<table border="1">
<%
Do While Not rstSimple.EOF
%>
<tr>
<td><%= rstSimple.Fields("username").Value %></td>
<td><%= rstSimple.Fields("password").Value %></td>
<td><%= rstSimple.Fields("email").Value %></td>
</tr>
<%
rstSimple.MoveNext
Loop
%>
</table>

How can I make the email field a hyper link?

Charlie

 

[Ray at]

How would you do it if you hard"coded" the HTML?

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

Right? So, substitute the e-mail address for the variable (or recordset
value) that represents the e-mail address. Let's put the value into a
variable to make it simpler and a bit more efficient though.


<%
sEmail = rstSimple.Fields("email").Value
%>

<table border="1">
<%
Do While Not rstSimple.EOF
%>
<tr>
<td><%= rstSimple.Fields("username").Value %></td>
<td><%= rstSimple.Fields("password").Value %></td>
<td><a href="mailto:<%=sEmail%>"><%=sEmail%></a></td>
</tr>
<%
rstSimple.MoveNext
Loop
%>
</table>


Ray at home

 

[Chas]

Thanks so much this is great!
Charlie

How would you do it if you hard"coded" the HTML?

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

Right? So, substitute the e-mail address for the variable (or recordset
value) that represents the e-mail address. Let's put the value into a
variable to make it simpler and a bit more efficient though.

<%
sEmail = rstSimple.Fields("email").Value
%>

<table border="1">
<%
Do While Not rstSimple.EOF
%>
<tr>
<td><%= rstSimple.Fields("username").Value %></td>
<td><%= rstSimple.Fields("password").Value %></td>
<td><a href="mailto:<%=sEmail%>"><%=sEmail%></a></td>
</tr>
<%
rstSimple.MoveNext
Loop
%>
</table>

Ray at home

 

[Aaron Bertrand [MVP]]

<%

sEmail = rstSimple.Fields("email").Value
%>

<table border="1">
<%
Do While Not rstSimple.EOF
%>

Well, you probably want to assign the value inside the loop. ;-)

 

[Ray at]

Oh yeah. Good point. :]

Ray at home

Well, you probably want to assign the value inside the loop. ;-)