Automate emails with Google Sheets mailing list (50 or more addresses)
How to automate emails to 50-plus email addresses using Google Apps Script.
Google Apps Script's EmailApp and MailApp have a 50 address limitation. This video provides one solution to use one script to send one email to more than 50 addresses. There are caveats:
1. you will be sending email in batches of 50, so you will not have one email — this solution means you have one script that sends multiple versions of one email message
2. Google has quotas, which means you will be limited in the maximum number of recipients you can send email to in one day.
PLEASE CONSULT THE DOCUMENTATION BEFORE PUSHING INTO PRODUCTION: https://developers.google.com/apps-sc...
I don't want you to be locked out if you have critical messages that need to be sent from other applications.