Merge Rows in Batches

How to merge rows in smaller batches to avoid errors?

This article describes how to merge rows in batches in order to overcome error messages such as:

1. Service Documents failed while accessing document with ID [Google Doc ID], when merging many rows into a single document and Google cannot handle the load.

2. NetworkConnection failure due to HTTP 0, when emails sent with personalized PDF attachments take a long time to send.

From Google Docs

Step 1: Create new column

In Google Sheets, create a new column and name it whatever you want (e.g., Merged).

Step 2: Click Options

In Google Docs, click on Options in the Mail Merge sidebar to open the Options dialog box.

Step 3: Select Merged column

Select the Merged column from the Track Merged Rows and Merge Specific Rows drop-down menus.

This enables Mail Merge add-on to track which rows have been merged.

Step 4: Set Batch Size

Set the Batch Size to as many rows as you need to merge at once.

Batches of 50 or 80 are recommended to make sure the mail merge occurs smoothly.

Step 5: Click Save

Click on Save to apply the changes.

Step 6: Select Letters & click Merge

Select Letters from the Merge To list, and then click on Merge to merge the first batch.

NOTE: Once the first batch is merged, you need to manually click on Merge again to merge the next batch. Repeat until all batches are merged.

From Google Sheets

Step 1: Enter Batch Size

Select the To Letters tab and enter the Batch Size number.

Step 2: Start Merging in Batches

Click the Merge Letters button to start merging the first batch.

NOTE: Once the first batch is merged, you need to manually click on Merge Letters again to merge the next batch. Repeat until all batches are merged.