Dynamic hyperlink wtih merge field

Is it possible to create a hyperlink containing a merge field?

I am using the same hyperlink but need to insert a merge field at the end so that it picks up a specific code to direct people to a personalised web page.

I can insert the link with the mail merge directly into the document (which works) but I want to change the text that is displayed and it won't allow me to do that.


Thank you