Hi

I have an application that sends an email based on the results of the recordset.

How do you get a repeat region (loop) into the body of a email.

<%
Name = "Press-Store"
SenderEmail = "awsdesigns@gmail.com"
Subject = "Press-Store ~ File Uploaded ("&filename&" - "&SetBytes&")"
Recipient = (RSp.Fields.Item("email").Value)
Body =

:cry:
'this bit i need in the declared variable (Body)

<%
While ((Repeat3__numRows <> 0) AND (NOT RSfiles.EOF))
%>
<%=(RSfilesus.Fields.Item("filename").Value)%><p>
<%
Repeat3__index=Repeat3__index+1
Repeat3__numRows=Repeat3__numRows-1
RSfiles.MoveNext()
Wend
%>

:rolleyes:

Set JMail = Server.CreateObject("JMail.SMTPMail")
JMail.ServerAddress = "localhost"
JMail.Sender = Senderemail
JMail.Subject = Subject
JMail.AddRecipient Recipient
JMail.ContentType = "text/html"
JMail.Body = Body
JMail.Priority = 3
JMail.Execute
%>

I know this code is far from right but it is basicaly what i need help with

Body = ""


<%
While ((Repeat3__numRows <> 0) AND (NOT RSfiles.EOF))

Body = Body & RSfilesus.Fields.Item("filename").Value & "<p>"

Repeat3__index=Repeat3__index+1
Repeat3__numRows=Repeat3__numRows-1
RSfiles.MoveNext()
Wend
%>

Thanx a million.

How could i have been that stupid!!! I have done this millions of times (not for the same reason though)

Don't be so hard on yourself, we all have days like this, that's what communities like this are for. :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.