(2) Not all variables are required.
The variables are presented as “query string parameters”, delimited with the ampersand (?)
Creating the link
In Excel, theHYPERLINK functioncan be used to create links.
The basic syntax is:
The link itself is a text string that represents a valid link.
The link text (called “friendly name” in Excel) is the text displayed to a user.
The formula is a bit tricky.
In the code below, the ampersands in yellow are used for concatenation in Excel.
In quick testing with Gmail and Outlook, missing parameters seem to be ignored gracefully.
The behavior in other email applications may vary.
Related functions
HYPERLINK Function
The Excel HYPERLINK function returns a hyperlink to a given destination.
you’re free to use HYPERLINK to create a clickable hyperlink with a formula.
