Schedule Emails

How do I schedule emails?

This article describes how to setup email scheduling in Google Docs, enabling emails to be scheduled for sending on a specific date/time.

Available From the Google Docs Add-on Only

Watch a Video Tutorial

Watch this quick tutorial or follow the step-by-step instructions below to find out how to schedule emails from Google Docs.

Step 1

In Google Sheets, create two new columns and name the first Merged Status and the second Scheduled.

Step 2

Enter the date/time you want the email to be sent in the Scheduled column.

NOTE:

Step 3

In Google Docs, Open the Options window by clicking the button in the Mail Merge sidebar.

Step 4

Set the Scheduled column for the Email Scheduled Field drop-down.

Step 5

Set the Merged Status column for both the Track Merged Rows and Merge Specific Rows drop-downs.

Step 6

Click Save to apply changes.

Step 7

Select Emails under Merge To and press the Merge button.

The email schedule process will start running in the background; there is no need to leave the document template open or to leave your computer running while the email schedule process sends your emails.

NOTE:

Advanced Feature: Monitor the Email Schedule Process

Step 1

In Google Docs, open the Options window by clicking the button in the Mail Merge sidebar.

Step 2

Click Schedule Status.

This will open the Email Schedule Process dialog box, where you can see the status of the email schedule process, the last execution time, the number of emails in the queue and any errors that have occurred.

Advanced Feature: Stop the Email Schedule Process

Step 1

In Google Docs, open the Options window by clicking the button in the Mail Merge sidebar.

Step 2

Set (N/A) for the Email Scheduled Field drop-down.

Step 3

Click Save to apply changes.

You will see a message confirming that the email schedule process is being deactivated.

NOTE: To restart the email schedule process, set the Scheduled column again for the Email Scheduled Field drop-down, click Save, and then click the Merge button.

Advanced Feature: Multiple Email Schedules

To setup multiple email schedules, please refer to this article.