Mail merge wizard (eMail), insert unique hyperlink: how?

Hello,

In Writer’s “Mail Merge Wizard” I’m trying to create a mailing with in each message a unique hyperlink. The main part of the hyperlink is static and the unique part (uuid) is in the database. I can create a visually valid hyperlink, but not clickable. Either it misses the unique part or it has reference code instead of the actual value.

Any suggestions on how to fix this?

Kind regards, Maarten