How to Schedule Emails for Sending Later with Gmail Mail Merge

Published in: Mail Merge for Gmail

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 email for recipients in that row will go out +/- 30 minutes of your scheduled time.

Following are some commonly asked question around scheduling in Mail merge for Gmail.

Q: What is the correct format for specifying the scheduled date and time in the mail merge sheet?

The format depends on your Spreadsheet locale and thus may be different for different users. To know the exact date time format for your sheet, go to an empty cell in the sheet and type the formula =NOW() and press Enter. It will show you the format for your sheet.

Q: My emails are not getting sent as per schedule?

The email scheduler is not accurate by the minute due to a 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?

Please see this workaround for sending recurring emails with Mail merge.

Published in: Mail Merge for Gmail

Looking for something? Find here!

Meet the Author

Web Geek, Google Developer Expert
Amit Agarwal

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India. He is the developer of Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

Get in touch