Mail merge with hyperlinks ​

You can link emails, URLs or files.

Simple link ​

Select fields, you'd like to generate as links (1).

Activate the checkbox Is link (2).

Preview the mail merge.
The cursor changes to a link after mouse over.

Markdown link ​

You can show different text or content in the generated document, but define a different link target.

Showing different content or text in the generated document, but forwarding the link to a different target, can be achieved with Markdown links.

A Markdown link has the following format:

[Text to display](Email_URL_or_Filename)

e.g.

[More info](https://moreinfo.com?id=12345)

[Text to display](Email_URL_or_Filename)

e.g.

[More info](https://moreinfo.com?id=12345)

Lets assume, there are two fields,

• Picture, full size picture (col. C)
• Thumb, a small version (col. D)

Create additional field MarkdownLink and use the concat formula for creating the markdown link from the existing fields.

Copy the formula cell E2 for all rows in the column MarkdownLink (col. E).

Switch to the Text View.

Remove the previously created field Thumb and insert the new one - MarkdownLink, as a picture (like above).

Select the field and set it as a link.

Videos ​

Mail merge into PDF file and insert QR code and link ​

Master detail mail merge with QR codes and URL links ​

Master detail mail merge with pictures and markdown links ​