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
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:
Just type the merge field in the Email Subject. For example if you have a column called 'Fullname', you can type the following:
That's all! Your emails will have their subject personalized like "Att: Andrew Smith"
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.
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.
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).
Yes you can. Just follow these steps:
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.
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'.
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: