Help (FAQ)

How can I include an attachment when merging to emails?

posted 22 Jun 2016, 11:50 by Andrew Dimech

You can do this by linking to your attachment from your Google Drive as follows;

1. Add your attachment to your Google Drive (if not already there).
2. Right click the file from Google Drive and click 'Get shareable link'.
3. Copy the link from the dialog and paste it in your document template

How can I manage users in a site license?

posted 16 Jan 2016, 02:51 by Andrew Dimech   [ updated 8 Feb 2017, 08:16 by Andrew Dimech ]

You don't necessarily have to! Once the maximum number of licensed users is reached, new users will automatically disable the oldest inactive account. This frees administrators from managing the Add-on users.

What if I want to restrict which users are allowed to install the Add-on? 
Yes you can. Ask your IT Administrator to login to the Google Administrator Console first. Then paste the link below for more instructions from Google:

If your administrator is not in a position to do this, do not buy a site license. Instead you have to buy individual licenses. Otherwise other users in your site/domain can take your license.

How can my users install the add-on?
They can either search for the 'Mail Merge' add-on from Google Docs Add-on->Get Add-ons... menu or you can simply give them this link to install it:

2. How can I put a Merge Field in the Email Subject?

posted 14 Jan 2016, 10:36 by Andrew Dimech

Just type the merge field in the Email Subject. For example if you have a column called 'Fullname', you can type the following:

Att: *|Fullname|*

That's all! Your emails will have their subject personalized like "Att: Andrew Smith"

1. How can I merge specific rows?

posted 10 Jan 2016, 08:28 by Andrew Dimech

Create a column in your sheet and name it whatever you want. Say ‘Exclude Rows’. Then type 'yes' or whatever (as long as its not empty) in the rows you want to exclude from merging.

Then open the Options dialog and set the ‘Exclude Rows’ in the ‘Merge Specific Rows’ option. Click save to apply changes.

When you merge to emails or letters, rows with a value in 'Exclude Rows' will be excluded from merging.

Are Headers/Footers supported?

posted 1 Jan 2016, 10:32 by Andrew Dimech

They are somewhat supported. However they don't really make sense when merging. If you have issues with them it is best to move the content to the document's body.

How do I fix blank pages when I merge to letters?

posted 1 Jan 2016, 10:31 by Andrew Dimech

In your document template make sure you leave some room for the text in your page grow. If you have content down to your footer most likely you will get blank pages into your merged document. Its best if you leave a couple of lines blank (not even carriage returns).

Can you merge into letters using images from Google Drive?

posted 1 Jan 2016, 10:29 by Andrew Dimech   [ updated 14 Feb 2017, 11:18 by Andrew Dimech ]

Yes you can. Just follow these steps:

  1. Locate the image in Google Drive.

  2. Right click the image and click ‘Get shareable link’.

  3. Copy the link and paste it in your Sheet as shown in the image below.

  4. The column containing the links should be tagged with the value <img>. This tag would indicate to the Add-on that it should download the image from the link and not simply copy the url when merging.

7. What about security? Is the data in my sheet or document compromised by the add-on?

posted 1 Jan 2016, 10:29 by Andrew Dimech   [ updated 22 Nov 2016, 13:07 by Andrew Dimech ]

Customer's security is taken very seriously. The data processed by the add-on is NOT stored or transmitted to anyone for analysis. Not even the add-on’s owner.

Why aren’t my images showing?

posted 1 Jan 2016, 10:28 by Andrew Dimech   [ updated 14 Feb 2017, 11:00 by Andrew Dimech ]

Only images with the ‘In line’ option are support when merging into a single document.


a) Organize your images and text into table cells (without showing the border) and set your images with the 'In Line' option.

b) Click the Options dialog to change the 'Merge to Letters into' field to 'Multiple Documents'.

The format (or Locale) for my date, number or currency fields is lost. What can I do?

posted 1 Jan 2016, 10:27 by Andrew Dimech   [ updated 14 Feb 2017, 11:06 by Andrew Dimech ]

For example as shown in image below, the German date ‘3 Februar 1980’ will be merged to English ‘3 February 1980’. As a workaround do the following:

  1. Create another column (‘DOBMerge’ as in the example below)

  2. Use the =to_text(cell) formula to convert your field into text

  3. In your document use the *|DOBMerge|* field instead of the *|DOB|* field

  4. You are now ready to merge

1-10 of 17