I am using Google Sheets to run mail merges using the script editor; it references a cell with an email address and a cell with the body of the email. I am able to concatenate a number of other columns to generate the merge field values.
I am only able to insert plain text URLs, and in most cases they render as links in browsers.
However, I have recipient-specific URLs that are pretty long, and I'd like to alias them, in the body of the email. Basically, I want to get what would be the resulting links for the inputs below:
<a href=https://www.recipient-site.com>Your Site</a> VIA
=HYPERLINK("https://www.recipient-site.com","Your Site") VIA
I have tried
=hyperlink(G4,F4) where the values are from cells, and it renders correctly in the cell, but just shows the alias as plain text in the email.