links as a custom field

We are wanting to send out an email that has a unique link in it for each recipient in our email list.  It is not a link to our website, but to an outside organization.  From what I've read, the Dynamic Link won't work because it isn't to our website associated with our account.

So what we want to do is have text that is clickable.

The contact list would be something like:

lastname, firstname, email address, unique link

Smith, Joe, email@email.com , link1

Jones, John, email2@email.com, link3

Johnson, Lisa email3@email.com, link4

We would like the unique link to appear something like

Click here to take the survey    where "Click here..." is clickable, but it is also a custom field in the "contact details".

I know this sounds confusing.  Any suggestions?

Thank you!

Leanne