Results 1 to 3 of 3

Thread: CDONTS

  1. #1
    viren Guest

    Default CDONTS

    Can I do something like <BR><BR>check through all the records in the database, and in each records if the time in one of the fields when compared to the time (at current) is less then 72 hours , and if one of the field say like Reply is empty then send a mail to a specific person, the person email address is derived from the DB. <BR><BR>my attempt is like below:<BR><BR>Dim <BR>ResponseTime <BR>ResponseTime = rs("otime") + 72<BR><BR>If ResponseTime &#060; time() and Ttype = "" Then<BR><BR>&#060;% <BR><BR>Dim mail <BR>Set mail = server.createobject("CDONTS.Newmail") <BR>mail.From = "" <BR>mail.To = ""<BR>mail.subject = "testing" <BR>mail.body = "testing to send auto respond by hours" <BR>mail.send <BR><BR>%&#062;

  2. #2
    Join Date
    Dec 1969

    Default RE: CDONTS

    You will have run a For Loop or While Loop to go through your whole recordset.

  3. #3
    viren Guest

    Default Need HELP, Need More explanation

    Need HELP, Need More explanation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts