Hi<BR><BR>Could someone give me some guidance on whether the following code will work with ASP:WATCH THE WRAP!<BR><BR>strSQL = "SELECT *,&#039;ERS&#039; + format(ID,&#039;1000&#039;) as JobID FROM vacancies WHERE [VacancyDate]&#060;Now()-60 ORDER BY JobCatagory DESC " <BR>rs.Open strSQL, goConn, adForwardOnly <BR><BR>If rs.RecordCount &#062; 0 Then <BR><BR>Also could you tell me how to incorporate this to work with my Jmail email code as I am getting somewhat lost.<BR><BR>Thank you<BR>Karl