In this article we will quickly look at how to add the hyperlink to the RTF template to get the output with hyperlinks (excel/pdf).
Normally when we insert the fields into the RTF template, they will appear as text by default. Even if the underlying data contains a hyperlink, they will be displayed as text.
Steps to add a hyperlink to RTF template:
First We need to insert the form field to the RTF template. We can use the Table Wizard or insert the field manually.
Once we added the field to the RTF, right click on the field and select link

Next, we need to add the code that will display the hyperlink

In the address box, we need to the add the XML tag name for email address or hyperlink field.
%7bPERSONAL_EMAIL_ADDRESS%7d
OR
{PERSONAL_EMAIL_ADDRESS}
and click OK.
The latest template will look like:

And sample output will look like:

On the output if we click on hyperlink, it will open up a default mailbox and tries to send an email. If there is an actual hyperlink, it will open up the URL on default browser.