0 Replies Latest reply on Mar 11, 2007 3:58 AM by JohnGree

    frequency

    JohnGree Level 1
      Hi i have a scheduled email system, where a user selects a time and date, which gets converted to my server time and date, and then gets put into my database with the email message,

      the server then sends out emails if the time and date is less than the current server datetime.

      i have added a frequency table, so now i need some code to send out emails every week if the time_unit = weekly etc.


      i have this code below already working can someone help me adjust it for the frequency.


      ***frequency_table***

      Appt_ID = G6pCf
      Time_Unit = Weekly, monthly etc


      ***appoint_table***

      GroupView = G6pCf
      Message = email message here
      ServerSMS = datetime that the message gets sent ou the first time