How do I mail merge with hyperlinks?
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.
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 mail merge hyperlink reference (or mail merge URL link), such as https://www.quicklution.com, while the Hyperlink Text column would hold its representive text such as Quicklution.
In the name of the Hyperlink URL column, add the tag <link|X> where 'X' is the letter of the Hyperlink Text column.
This will ensure that the mail merge link in the Hyperlink URL column is associated with the text in the Hyperlink Text column.
For each data row, insert a mail merge 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 mail merge link URL (column G) links to a file link attachment containing a job role description specific to each employee's job role.
In your merge template, insert the hyperlink mergefield as you would for any other merge field.
In both examples, the merge field *|Hyperlink URL <link|H>|* is added.
Example 1 - Personalized Mail Merge Hyperlink Text
Example 2 - Same Mail Merge Hyperlink Text
Both examples above show how to insert a hyperlink in a mail merge email and thereby mail merge with attachments.
Mail Merge with Attachments Using Hyperlinks
When you mail merge a Google Drive file hyperlink to email, it will appear as an attachment in Gmail. In this instance, mail merging with a hyperlink can be used as an alternative to mail merging with a file attachment, as shown in the screenshots below.
Link to any Google Drive file
Links to Google Drive files are automatically shown as attachments