How to Schedule Mail Merge Emails from an Excel Date and Time
Question details
The user wants to automatically schedule standard mail merge emails based on specific dates and times stored in an Excel data source.
- Product
- Excel and Outlook
- Device & OS
- not provided
- Scenario
- Executing a mail merge where individual emails are automatically held and sent at the exact date and time specified in their corresponding Excel data row.
- Observed behavior
- Standard mail merge tools send emails immediately upon completion and do not natively use an Excel date or time column to defer delivery automatically.
Ensure that your Excel date and time column is properly formatted as a 'Date' data type, and verify that your Outlook client is connected to a supported Microsoft Exchange account if you intend to use native delay delivery features.
Use Power Automate for Row-Based Date and Time Scheduling
Using Power Automate is the most robust way to read row-by-row Excel dates and trigger scheduled emails automatically.
Since the standard Word/Excel mail merge does not process row-level time delays natively, Microsoft Power Automate can be used to read your Excel table and send emails precisely at the scheduled time in each row.
Open your Excel data source, highlight your data including the Date/Time column, and press Ctrl+T to format it as a Table. Save this file to OneDrive or SharePoint.
Log into Power Automate and create a new Scheduled or Automated Cloud Flow. Add the 'List rows present in a table' action for Excel Online to pull your data.
Inside an 'Apply to each' loop, insert the 'Delay until' action. Map the timestamp parameter to the specific Date/Time column from your Excel dynamic content.
Add the 'Send an email (V2)' action immediately after the Delay action. Populate the To, Subject, and Body fields using your Excel columns, and save the flow.
Use Outlook Delay Delivery for Batched Sending
Best for deferring a whole batch of mail merge emails to a specific time, requiring an Exchange account.
Utilize the Merge Tools Add-in
A third-party add-in that provides a built-in 'Defer Sending' option for complex mail merge operations.
Looking for a Lightweight Office Suite with Mail Merge?
While automated email scheduling heavily relies on server-side Exchange integration, WPS Office offers a completely free, fast, and highly compatible suite for preparing your mail merge templates and managing large Excel data files seamlessly.
- 1. Download and Install WPS Office: Visit the official WPS Office website to download the suite for free.
- 2. Prepare Your Data Source: Open your .xlsx file in WPS Spreadsheet to easily organize and format your mailing list.
- 3. Create Your Mail Merge: Use WPS Writer's intuitive Mailings tab to link your spreadsheet, insert merge fields, and generate your final documents.
Frequently Asked Questions
Can standard Word mail merge natively read an Excel scheduled time?
No, the native mail merge feature in Word pushes emails directly to your Outlook Outbox for immediate sending. It cannot read a date or time column from your data source to automatically delay sending per recipient.
Does Outlook Delay Delivery work without an Exchange account?
If you are using a POP3 or IMAP account, you can use Delay Delivery, but the Outlook application must remain open and running at the specified delivery time. With an Exchange account, the server handles the delay, so Outlook can be closed.
Why does Power Automate fail to recognize my Excel date and time?
Power Automate reads Excel dates as serial numbers by default unless specified. In your Power Automate 'List rows present in a table' settings, ensure 'DateTime Format' is set to 'ISO 8601' so the delay action processes the schedule correctly.
What is the Merge Tools Add-in?
It is a popular third-party extension for Microsoft Word created by an MVP. It provides advanced mail merge features beyond native capabilities, including sending attachments, combining documents, and deferring batch sending.
