To send automatic email to parents of defaulter students from the given list
- Open Google spreadsheet
- Go to Tools--> Script Editor
- Paste the script here
Expected Format-
- 1st column should be roll number,followed by various subjects,and then column of email and name.
- Roll number column (i.e. including heading) should start from 4th row.
- Defaulter list in sheet1 is printed from column 20 which starts with roll number.
- Data is transfered from R4 to AI26 of sheet1 to sheet2.
- This is validated only for 4 subjects.
- Alternative for Replace function to be done.