Using Custom URL Field in Email Template

Using Custom URL Field in Email Template

We have a custom field called "Product URL" (URL field).  Every contact has unique data in the URL field.

Within the email template we want to create a text link to that merged custom field. 

===
Example:

Hello.  Please visit this link.

====

The problem we run into is if we highlight the text and click the hyperlink icon it asks for the URL.  In there is where we place the merge field id (e.g. $[UD:PRODUCTURL||]$ ) but when the link is received by the email contact it doesn't work properly. 

Side note, We have tried making the field a TEXT field but the URL is longer that 50 characters.

How do we code the email template to make "Please visit this link" a hyperlink to the unique URL in the product url merge tag?