I am tearing my hair out, I have spent 20 hours on this.
In a nutshell,
I have an excel sheet which has a reference number, along with name, time of appt etc.
That reference number is CONCATENATED to get a google URL to make a QR code.

When I mailmerge the other fields come up, but the QR code does not.
I have used the insertpicture, and it does come up, but it's the same QR code for all the test emails, I refresh it, and then it will update, but only for that one person.
I have done the mail merge to a new document, CTRL A, f9 and all the images load up, but I don't want to print them!!
I have then thought, if I do the mergebarcode function, and just link it to the reference number, it does put a QR code, but does not send it to email, but printing it, it will.
I then thought about combining mergebarcode with insertpicture, but I just get an error message.
This is driving me mad, as all I want is a QR code to show up in the mail merge email, so I can scan it when people arrive.
Surely there has to be a solution. All the solutions seem to be for printing documents, not emailing.
I also used an array from another solution to get a HTML code to get the URL as <img> and put that in another Excel Column, but can't seem to get it to embed HTML into the word email merge.
I am using office 2013.
Thank you.