Merge Hyperlinks

How do I mail merge with attachments?

This article describes how to merge hyperlinks, enabling a personalized hyperlink to be sent to each email recipient. When combined with a file sharing service such as Google Drive, merging with hyperlinks can be used to mail merge with attachments.

Step 1

In Google Sheets, create two new columns and name them whatever you want, e.g. Hyperlink URL and Hyperlink Text.

The Hyperlink URL column would hold the hyperlink reference (or URL), such as https://www.quicklution.com, while the Hyperlink Text column would hold its representive text such as Quicklution.

Step 2

In the name of the Hyperlink URL column, add the tag <link|X> where 'X' is the letter of the Hyperlink Text column.

Step 3

For each data row, add a hyperlink URL and hyperlink text in the respective columns.

In the two examples below, job role description documents are shared with company employees as file link attachments. In both examples , the hyperlink URL (column G) links to a file link attachment containing a job role description specific to each employee's job role.

Step 4

In your merge template, insert the hyperlink URL *|merge field|* as you would for any other merge field.

In both examples, the merge field *|Hyperlink URL <link|H>|* is added.

Example 1 - Personalized Hyperlink Text

Merge Template

Merged Content

Example 2 - Same Hyperlink Text

Merge Template

Merged Content

Both examples above show how you can mail merge with attachments.