seems to be simply syntax problem

[cisco777]

I am making progress on writing the excel file and I want to thank everyone for their help.

I am trying to make the email address clickable when writing the excel file but can not seem to get by the syntax.

everything works except the email line.

The below is the code.


bxtract.WriteLine("<tr>")
bxtract.WriteLine("<td width=""20%"" valign=""top"">" & strFname & "</td>")
bxtract.WriteLine("<td width=""20%"" valign=""top"">" & strLname & "</td>")
bxtract.WriteLine("<td width=""20%"" valign=""top"">" & "<a href=""' & " & mailto: <%=strEmail%> & """> strEmail</a>" & "</td>")
bxtract.WriteLine("</tr>")


Thank you.

 

[bslintx]

are you trying to do this in an asp page? <%=strEmail%>

perhaps get rid of the asp code (since strEmail is a variable) and concatenate the string and variables correctly

bxtract.WriteLine("<td width=""20%"" valign=""top""><a href=""mailto:" & strEmail & """>" & strEmail & "</a></td>")