&nbsp;<BR>Hi all,<BR>I have to retrieve expired records from the database and automatically send email including information about each record <BR> from select statement .I&#039;m just wondering if it possible to send email for each record or maybe I can send one email per day <BR>but I need whole information included.<BR>My Email output doesn&#039;t look good.<BR>As I know I can use line breaks &vbcrlf to separate information,<BR>any idea how can I separate information from my varable p , m ....<BR>if I have for example 10 records and i&#039;d like to show 10 Managers name&#039;s <BR>a = DateAdd("d", -14, dtNow) <BR> <BR> sSQL= "Select * from test WHERE RequestDate &#060;= &#039;" & a & "&#039;" <BR> Set RS=objConnection.Execute(sSQL)<BR>Response.Write (sSQL)<BR>WHILE Not RS.EOF <BR>p = p + RS("CostManName")<BR>m = m + RS("NewCostManName")<BR>RS.MoveNext<BR>Wend<BR><BR >varSubject= "e-Form Request has been expired!"<BR>varBody = varBody & "Please contact to the following Cost Centre Managers :" & vbCrLf & vbCrLf <BR>varBody = varBody & " 1." & p & vbCrLf & vbCrLf <BR>varBody = varBody & " 2." & m & vbCrLf & vbCrLf <BR> I wiil be appreciated for any help <BR>and If it possible to have a piece of code ?<BR><BR>Thank you an advance.<BR>Angelika.