The Mail Merge add-on allows you to schedule email messages so that they can be sent later at your preferred date and time automatically.
When you create a new Mail merge template, it includes a column called “Scheduled Date”. You can put the date and time in this column and the merge for that row will happen at the scheduled time.
Here are some commonly asked question around scheduling in Mail merge for Gmail.
Q: My emails are not getting sent as per schedule?
The email scheduler is not accurate by the minute due to limitation in the Google API. Email messages can be sent anywhere between +/- 30 minutes of the scheduled time.
For instance, if you set the scheduled date as 2/20/2015 04:30, the email can go out anytime between 4 to 5 AM.
Q: I’ve scheduled a bunch of emails. How do I unschedule them?
There are two ways to unschedule emails. You can either clear the date in the corresponding Scheduled Date column of the spreadsheet or you can simply delete the row from the spreadsheet.
Q: My scheduled emails are not getting sent at all?
It is likely that you email quota for the day is over. Else, the scheduler has stopped for some technical reason. You can go to the Add-ons – Mail Merge with Attachments – Configure menu and run Mail Merge again to resume the scheduler.
Q: Can I send recurring email with Mail Merge?
This is currently not supported.