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 = "firstname.lastname@example.org"
Subject = "Press-Store ~ File Uploaded ("&filename&" - "&SetBytes&")"
Recipient = (RSp.Fields.Item("email").Value)
'this bit i need in the declared variable (Body)
While ((Repeat3__numRows <> 0) AND (NOT RSfiles.EOF))
Set JMail = Server.CreateObject("JMail.SMTPMail")
JMail.ServerAddress = "localhost"
JMail.Sender = Senderemail
JMail.Subject = Subject
JMail.ContentType = "text/html"
JMail.Body = Body
JMail.Priority = 3
I know this code is far from right but it is basicaly what i need help with