ASP Pulling Email from access

[seanmayhew]

I have a database that has an email column that either contains an email address someemailaddy@mail.com or a value "n/a" All I want to do is loop through the column in ASP by checking to see if the "@" is in the address and if it is feed the email address into a mailto: href tag

I think something is wrong with my code because it just returns the name but not the href.

<% IF InStr(1, contactObjRS("Email"), "@") = 1Then %>
<a href="<A href='mailto%=contactObjRS("Email'>mailto%=contactObjRS("Email") %>"><%=contactObjRS("FirstName") %>
<%Response.Write(" ") %>
<%=contactObjRS("LastName") %></a></font>
<% Else %>
<%=contactObjRS("FirstName") %>
<%Response.Write(" ") %>
<%=contactObjRS("LastName") %>
<% End If %>



Any help would be greatly appreciated.

[fmavituna]

Could you try this;

<% IF InStr(contactObjRS("Email" ), "@") > 0 Then %>
<a href="<%=contactObjRS("Email")%>"><%=contactObjRS("FirstName" ) %> </a>
<%Response.Write(" " ) %>
<%=contactObjRS("LastName" ) %></a></font> 
<% Else %>
<%=contactObjRS("FirstName" ) %> 
<%Response.Write(" " ) %>
<%=contactObjRS("LastName" ) %> 
<% End If %>

[seanmayhew]

Worked perfect Thank You!

[fmavituna]

you're welcome