0
votes

Hi I am having trouble with appscript code .he, I am looking to generate email reminders for tasks that are still in “assigned” status end of the month!

 Function sendEmail(){
 Bar sheet =              spreadsheet.getactivesheet();
    Var startrow = 3;
    Var numrows = 43;
    Var daterange =       sheet.getrange(setrow, 3, numrows, 43)
     Var data= data range.getvalues();
      For (i in data) {
       Var row= dat[i] {
        Var emailaddress = row [0];
    Var message = “pending task” + row[1];
    Var subject = “pending task”
  Mailapp.sendemail(emailaddress, subject, message);
 }
}

}

  1. List item

Pulling email address from column 1, task name from column 2, status field “assigned

I have to apologize for my poor English skill. Unfortunately, I cannot understand your question from List item Pulling email address from column 1, task name from column 2, status field “assigned. Can I ask you about the detail of the current issue of your script and your goal? - Tanaike