How specifically does the code found in this article need to be modified to allow for a specified email address column to inform who the reminder should go to?
I have an example spreadsheet here with the script provided from the blog post installed.
If it helps explain, my comment to the article author is as follows:
...it almost seems as though in your section “Sending the Reminder Email” that the code could reference, instead of a static email address, a cell value that meets the criteria – i.e. the adjacent date column cell is within the proper time range to trigger
And the author's response:
Yes, that’s certainly something that can be done. It’s honestly a pretty simple extension of the logic – the MailApp.sendEmail call needs to be in the loop, rather than after it.
It looks as though I have the "what" – I just need the "how". I'll take advice or a code example/modification of my installed script
what about Bob
). Ask simple questions, and get simple answers and learn on the go. Best is to include a Google Spreadsheet and show the expected result.