Creating the merge field and then merging the document works and the URL changes with each new record { HYPERLINK { MERGEFIELD "URL" } * MERGEFORMAT }
However if I close the Word template and re open it, the merge field has changed to { HYPERLINK "https://example.co.nz" }, inserting the URL for the first record
All records therefore have the same URL.