I have the below spreadsheet where I can use a form Checkbox to set a value in columns (B,D,F) to true or false. From this point, what's the best way to generate an email with all the cells that were checked using the below example (VALUE=TRUE) in the respective places (e.g. to:ScienceGroup@school.edu; cc:me2@school.edu; bcc:prince@school.edu)? In some cases i would send to all in the same row, but its not always the case.
**The actual sheet I use is large with 125+ schools and almost all unique cc and bcc addresses.
**The actual sheet I use is large with 125+ schools and almost all unique cc and bcc addresses.
| Column A | Column B | Column C | Column D | Column E | Column F | |
|---|---|---|---|---|---|---|
| Class | To | toadd | CC | ccadd | BCC | bccadd |
| Math | [ ] Checkbox (FALSE value) | MathGroup@school.edu | [ ] Checkbox (FALSE value) | me@school.edu | [X ] Checkbox (TRUE value) | prince@school.edu |
| Science | [X] Checkbox (TRUE value) | ScienceGroup@school.edu | [ ] Checkbox (FALSE value) | me1@school.edu | [ ] Checkbox (FALSE value) | prince1@school.edu |
| History | [ ] Checkbox (FALSE value) | HistoryGroup@school.edu | [X] Checkbox (TRUE value) | me2@school.edu | [ ] Checkbox (FALSE value) | prince2@school.edu |
