Personalized Links

With MergeMail, you can send an email campaign with personalized links, so that each recipient receives a different, individualized link. You can use as many personalized links as you want.

To use personalized links, add a column in your spreadsheet (you can name the column anything that you want). In the column, you can use Google Sheet’s HYPERLINK function to create links. MergeMail supports two link formats:

=HYPERLINK("", "Google")


Note: MergeMail only supports the above formats. We don’t currently support using column references (e.g., =HYPERLINK(B2)) or other functions inside of the HYPERLINK.

See the “Link” column below for an example:

Mail merge links

When you create your MergeMail campaign, you can copy/paste the {{Link}} variable into your email:

Your outgoing email will then include the link (MergeMail will also add any click tracking that you’ve enabled):

We recommend testing this out using email previews prior to sending, so that you’re confident that your links will be set up in the way that you want them to be set up up for each recipient.