Merge in Batches

How do I merge in batches?

APPLICATION: You have hundreds of rows to merge, but merging them all in one go could result in error messages from Google services due to the high volume. Therefore, you merge in batches of 50 or 80 to ensure a smooth mail merge process.

From the Google Docs Add-on Only

Step 1

In Google Sheets, create a column in your sheet and name it whatever you want, e.g. Merged.

Step 2

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

Step 3

Select the Merged column for the Track Merged Rows and Merge Specific Rows fields.

This will enable the add-on to track which rows have been merged already.

Step 4

Set the Batch Size to however many rows you want to merge in one go.

Step 5

Click Save to apply changes.

Step 6

Merge the first batch by clicking the Merge button.

Confirm the batch size when prompted.

NOTE: Once the first batch is merged, you will need to manually press the Merge button again to merge the next batch.