This is operated on Google Apps Script.

It can let you send mails to many people by Gmail.

You can change some variable in the Mails content.

---

How to use it

1. Paste the code on the Google Apps Script.
2. Set the Name and Email list spreadsheet URL.
3. Add the variable you need.
4. Write the content of the mail. (this cannot use html...)
5. Execute it!!