I've go tone for you guys.... I

[imstillatwork]

I've go tone for you guys....

I have my mail.body = "" ok?
I want to insert this into the body

Do While Not rs.EOF

response.write rs("request_date&quot
response.write " "
response.write (&quot;<a href=linktopage.asp?id=&quot;&(rs(&quot;request_ID&quot)&&quot;&code=&quot;&(rs(&quot;ucode&quot)&&quot;>&quot;& rs(&quot;ven_name&quot &&quot;</a>&quot
response.write &quot;<br>&quot;

rs.movenext
Loop


How do I do that, since the mail.body only likes stuff on one line????????

 

[derren]

Hi

Rather than trying to squash everything onto one line, why not write to a variable instead, then do

yourvar = yourvar & rs(&quot;request_date&quot & &quot; <a href=linktopage.asp?id=&quot;&(rs(&quot;request_ID&quot)&&quot;&code=&quot;&(rs(&quot;ucode&quot)&&quot;>&quot;& rs(&quot;ven_name&quot &&quot;</a><br>&quot;

mail.body=yourvar Derren
[Mediocre talent - spread really thin]