I am creating a Mass Mailing Template for me to modify and use when I need to send similar emails to many people. The information required are in the spreadsheet, however I have missing parts in the code.

• After pressing the Send Email custom menu on the spreadsheet, here is the email message received by the sample recipient

• The Sent Email Log sheet.

References

• sendEmail() Advanced Parameters
• appendRow()