Hi all,<BR><BR>It seems that my mail sending is very unstable. sometimes it sends it doesn&#039;t. And for my date field (SQL server) sometimes it updated the fields, sometimes it doesn&#039;t. Have you guys any idea why because this problem is very critical to my system.<BR><BR>My update of date script looks like the below...<BR><BR>rs.Open "SELECT Received_date,Submit_date,Results_announce FROM BID_Checklist WHERE Bid_ref_no=&#039;" & bid_no & "&#039;",conn,2,2<BR>if not rs.EOF then <BR> rs("Received_date") = now() <BR> rs("Submit_date")=FormatDateTime(CDate(dte_subn),2 )<BR> if dte_res="" then<BR> rs("Results_announce")=null<BR> elseif dte_res&#060;&#062; "" then<BR> rs("Results_announce")=FormatDatetime(CDate(dte_re s),2)<BR> end if<BR>end if<BR>rs.Update<BR>rs.Close <BR><BR>Thanks a lot for the help..<BR>