File Attachments
How to add file attachments to my mail merge?
This article describes how to add file attachments to merged mmails, by using static or personalized file link attachments, or by creating personalized PDF file attachments.
Option A: Static file link attachments
Step 1: Add file
In Google Drive, add your file (if not already there) by clicking on New > File Upload.
Step 2: Click Get Link
Right-click the file on Google Drive, and then click on Get Link.
Step 3: Click Copy Link
Click on Copy Link to copy the link in the dialog box.
Step 4: Highlight text
In your merge template, highlight the text that you want to link to your file.
Step 5: Click Link
Open the Link option:
In Google Docs, right-click the highlighted text, and then click on Link.
In Google Sheets, Slides, and Forms, click on Link.
Google Docs
Google Sheets, Slides & Forms
Step 6: Paste link
Paste the link previously copied from Google Drive in the box provided.
Step 7: Click Apply or Insert Link
Confirm insertion of the link:
In Google Docs, click on Apply.
In Google Sheets, Slides, and Forms, click on Insert Link.
Google Docs
Google Sheets, Slides & Forms
Option B: Personalized file link attachments
Option B can be used to send a personalized file link attachment to each recipient using hyperlinks.
Instructions on how to mail merge with attachments can be found in this article.
Option C: Personalized PDF file attachments
From Google Docs & Google Slides
Option C can be used to create a personalized PDF file attachment for each data row. With this option you can personalize both the file attachment and the email body for each recipient using your *|merge fields|*.
Instructions for Google Docs can be found in this article.
Instructions for Google Slides can be found in this article.
File link attachment overview
Applicable to options A & B
Advantages of file link attachment compared to traditional file attachment
You can change or revoke access to your attachments after emails have been sent.
You can password protect your attachments.
Shared links are an environment-friendly option as you significantly reduce your data storage footprint. For example, a 2 MB attached file sent to 100 email addresses would consume 200 MB of data storage, whereas a shared link would consume next to nothing.
Spam filters can not block your emails due to attached files as your emails only contain links to attachments.
How file link attachment appears in Gmail
Email Template
Link to any Google Drive file
Merged Email
Links to Google Drive files are automatically shown as attachments