Add url variable to link in email template used for recordset loop in Send Email Behaviour

I have an email behaviour that is triggered by a ‘MySQLi Update Record’ behaviour. The email recipients are built from a recordset loop.

The email template that is used for the recipient email has a link in it that each recipient clicks to direct them to a web-form.

The problem I am having is I want to bind each recipients Database ID to a URL variable in the link they click so I can personalise the web-form ( pre-populate some of the form fields ) on the webpage they each get directed to.

Because the emails are sent via the recordset loop I can not work out how I can get the correct url variable ( ID ) into the link in each generated email.

What I am currently doing is directing them to a page which displays a list of all recipients where they select their name from the list which directs them to the web-form page. This works because I can directly access the links which is built from a repeat region from a record set and so I can place the ID from each database record in a URL variable in the link.

I did enquire about this over a year ago with Ray and he advised that I would probably need a support ticket. after a couple of failed attempts to connect on Skype, I had to put the project on hold


Thanks in Advance