Hyperlinks

How do I mail merge hyperlinks?

Step 1

In Google Sheets, create two columns in your sheet and name them whatever you want.

The first of the new columns will contain the hyperlink URLs and the second will contain the hyperlink text.

In the example below, column G will contain the hyperlink URLs and column H will contain the hyperlink text.

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.

In the example below, the tag is added to the name of column G and links to column H.

Step 3

Add hyperlink URLs and hyperlink text in the rows of the respective columns.

In the example below, hyperlinks to job role descriptions are added in column G and job titles are added to column H.

Step 4

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

In the example below, the merge field *|Hyperlink URL <link|H>|* has been added. Following the merge, the job title is displayed as the hyperlink text, which links to the job role description.

Merge Template

Merged Content