CDONTS Formatting

[Mintyman]

Ok, So I can't get my previous method to work so i'm trying a different way.
And I can't get this to work either ! Grrrr :o(

I'm getting an 'Expected End of Statement' :


Microsoft VBScript compilation error '800a0401'

Expected end of statement

/msds/confirm.asp, line 29

mail.body = "<table width=""600"" border=""0"" cellspacing=""0""
cellpadding=""0"">" & "<tr>" & "<font face=Arial size=2>" & "Thank you for
requesting a " & (MSDS.Fields.Item("description").Value) & " MSDS
information sheet from us." & "<br><br>" & "You can download the document "
& "<a href=" & """http://www.logitech.uk.com/MSDS/" &
""(MSDS.Fields.Item("Location").Value)"">"" & "here" & "</a>" & "</font>" &
"</tr>" & "</table>"
in the following code:<%
Set mail = Server.CreateObject("CDONTS.NewMail")
mail.From = "email@domain.com"
mail.To = Trim(Request.QueryString("Email"))
mail.subject ="MSDS Document downloaded"
mail.body = "<table width=""600"" border=""0"" cellspacing=""0""
cellpadding=""0"">" & "<tr>" & "<font face=Arial size=2>" & "Thank you for
requesting a " & (MSDS.Fields.Item("description").Value) & " MSDS
information sheet from us." & "<br><br>" & "You can download the document "
& "<a href=" & """http://www.domain.com/MSDS/" &
(MSDS.Fields.Item("Location").Value)">" & "here" & "</a>" & "</font>" &
"</tr>" & "</table>"

mail.MailFormat = 0
mail.BodyFormat = 0

mail.Send
Set mail = nothing
%>

It's something to do with the number of quotation marks but I can't find out
where i'm missing/adding any.

[Chris In Madison]

Looks like it's probably in your mail.body after the "Location" field
reference. Probably should be this (watch the wrap):

<%
Set mail = Server.CreateObject("CDONTS.NewMail")
mail.From = "email@domain.com"
mail.To = Trim(Request.QueryString("Email"))
mail.subject ="MSDS Document downloaded"
mail.body = "<table width=""600"" border=""0"" cellspacing=""0""
cellpadding=""0"">" & "<tr>" & "<font face=Arial size=2>" & "Thank you for
requesting a " & (MSDS.Fields.Item("description").Value) & " MSDS
information sheet from us." & "<br><br>" & "You can download the document "
& "<a href=" & """http://www.domain.com/MSDS/" &
(MSDS.Fields.Item("Location").Value) & """>" & "here" & "</a>" & "</font>" &
"</tr>" & "</table>"

mail.MailFormat = 0
mail.BodyFormat = 0

mail.Send
Set mail = nothing
%>

Best regards,
Chris

[Mintyman]

Thanks Chris :o)


"Chris In Madison" <cowens@cnwGOAWAYDIRTYRATSPAMMERS.com> wrote in message
news:d1cdn5$571$1@forums.macromedia.com...

> Looks like it's probably in your mail.body after the "Location" field
> reference. Probably should be this (watch the wrap):
>
> <%
> Set mail = Server.CreateObject("CDONTS.NewMail")
> mail.From = "email@domain.com"
> mail.To = Trim(Request.QueryString("Email"))
> mail.subject ="MSDS Document downloaded"
> mail.body = "<table width=""600"" border=""0"" cellspacing=""0""
> cellpadding=""0"">" & "<tr>" & "<font face=Arial size=2>" & "Thank you for
> requesting a " & (MSDS.Fields.Item("description").Value) & " MSDS
> information sheet from us." & "<br><br>" & "You can download the document

"

> & "<a href=" & """http://www.domain.com/MSDS/" &
> (MSDS.Fields.Item("Location").Value) & """>" & "here" & "</a>" & "</font>"

&

> "</tr>" & "</table>"
>
> mail.MailFormat = 0
> mail.BodyFormat = 0
>
> mail.Send
> Set mail = nothing
> %>
>
> Best regards,
> Chris
>
>