Debug a Google-Spreadsheet script

I created a google script that sends time based automated mail to hotel guests 1/ 0 day before an event. The code seems error free and I have debugged it as well and seems to be executing error free but the function function bookingmail(sheet) is not sending out the mail and the attachment even though the sheet meets the required conditions.

I have also activated the hourly trigger as well and included that in the code. I feel the issue could be from line 13 to line 15 in the "catch" or "attachment" command in the" first function: bookingSheets" To illustrate please see the script in the attachment. I am assuming I have made some simple error.

I am also attaching the script and the Spreadsheet for you to understand the structure. To ensure no double sending to same guest I have also added a formula in column "V"- so I do not need to modify the script to ensure that.

Thank you, Shaurya

JavaScript

ID projekta: #15150600

Več o projektu