Syntax problem with HTML output in email

Tom Petersen · Oct 23, 2003

I am using ASP to send the user an email with a clickable link that will
point back to the record id but I've got one line getting an expected end of
statement that I can't figure out...

& "<p><font face=""Verdana"" size=""2""><a
href=""http://sd-school/maint/maint.asp?action=edit&id=<%= objRS(""id"")
%>"">Click here to check the status of this request." & vbCrLf _

ideally I would just like the word 'here' to be the hyperlink, but first
things first...

Here is the whole mess, everything works great except for the above line,
because I can't figure out the right syntax...

emailBody = "<html>" & vbCrLf _
& "<head>" & vbCrLf _
& "<title>New Page 3</title> " & vbCrLf _
& "</head> " & vbCrLf _
& "<body> " & vbCrLf _
& "<div align=""center""> " & vbCrLf _
& "<table border=""0"" style=""border-collapse: collapse""
width=""64%"" id=""table1""> " & vbCrLf _
& " <tr> " & vbCrLf _
& "<td width=""4"" style=""border-left: 2px solid #3399FF;
border-top: 2px solid #3399FF""></td> " & vbCrLf _
& "<td width=""484"" style=""border-top:2px solid #3399FF;
border-left-width:1px; border-right-width:1px; border-bottom-width:1px""> "
& vbCrLf _
& "<p align=""center""> " & vbCrLf _
& "<img border=""0"" src=""http://sd-school/pic/sdsd.h1.gif""
width=""476"" height=""92""></td> " & vbCrLf _
& "<td width=""4"" style=""border-right:2px solid #3399FF;
border-top:2px solid #3399FF;"" ></td> " & vbCrLf _
& "</tr> " & vbCrLf _
& "<tr> " & vbCrLf _
& "<td width=""4"" style=""border-left: 2px solid #3399FF""></td> "
& vbCrLf _
& "<td width=""484""> " & vbCrLf _
& "<p align=""center""><span style=""letter-spacing: 2pt""><b> " &
vbCrLf _
& "<font face=Verdana>Maintenance Confirmation
Page</font></b></span></td> " & vbCrLf _
& "<td width=""4"" style=""border-right: 2px solid #3399FF""></td> "
& vbCrLf _
& "</tr> " & vbCrLf _
& "<tr> " & vbCrLf _
& "<td width=""4"" style=""border-left: 2px solid #3399FF;
border-bottom: 2px solid #3399FF""></td> " & vbCrLf _
& "<td width=""484"" style=""border-right-width: medium;
border-bottom: 2px solid #3399FF""> " & vbCrLf _
& "<hr noshade color=""#3399FF""> " & vbCrLf _
& "<p><font face=""Verdana"" size=""2""><a
href=""http://sd-school/maint/maint.asp?action=edit&id=<%= objRS(""id"")
%>"">Click here to check the status of this request." & vbCrLf _
& "Or click here to see all of your requests.<br> " & vbCrLf _
& " </font></td> " & vbCrLf _
& "<td width=""4"" style=""border-left-width: medium; border-right:
2px solid #3399FF; border-bottom: 2px solid #3399FF""></td> " & vbCrLf _
& "</tr> " & vbCrLf _
& "</table> " & vbCrLf _
& "</div> " & vbCrLf _
& "</body> " & vbCrLf _
& "</html> " & vbCrLf

TIA!
Tom

Ray at · Oct 23, 2003

I'd imagine it's the "" that you're using. Here are valid usages of quotes:

<%
Response.write "<a href=""something.com"">click me</a>"
%>

<%
sHTML = "<a href=""something.com?id=" & objRS("id") & """>click me</a>"
%>

<a href="something.com?id=<%=objRS("id")%>">click me</a>

So, in other words, you want to use objRS("id"), or better,
objRS.Fields.Item("id").Value, or better yet, objRS.Fields.Item(0).Value.
Or replace 0 with the index of the column from your select query.

Ray at work

Tom Petersen · Oct 23, 2003

It looks like I do need the double quotes, this line works fine
& " Click <a
href=""http://sd-school/maint/maint.asp?action=id&id="">here</a> to check
status.<br>" & vbCrLf _

but this does not
& " Click <a href="http://sd-school/maint/maint.asp?action=id&id=">here</a>
to check status.<br>" & vbCrLf _

But what is still throwing me off is how to insert the <%= objRS("id") %>
with the right syntax afer the &id=

Ray at · Oct 23, 2003

It depends if you're in a script block or out of it. Look at these
examples:

<html>
<head>
</head>
<body>
<a href="page.asp?id=<%=objRS("id")%>">click me</a>
</body>

<%
sVar = "1"

response.write "<html>"
response.write "<head>"
response.write "</head>"
response.write "<body>"
response.write "<a href=""page.asp?id=" & objRS("id") & """>click me</a>"
response.write "</body>"
%>

Can you see the difference?

Ray at work

Tom Petersen · Oct 24, 2003

Yep, got it thanks!!!!

Having trouble centering contents of td ?	3	May 2, 2023
Help with Visual Lightbox: Scripts	2	May 3, 2023
SendGrid email issue in responsive Gmail	1	Nov 4, 2021
I need help fixing my website	2	Oct 15, 2023
Help with my responsive home page	2	Dec 14, 2022
Help needed with thank you message	5	Sep 11, 2021
Image shifts to the right when export the page to pdf	4	May 5, 2023
Login button code	8	Jul 7, 2021

Syntax problem with HTML output in email

Tom Petersen

Ray at

Tom Petersen

Ray at

Tom Petersen

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads