I do a mailmerge from Access to Word that works fine. I export my query to Excel ,& the word template is connected to that Excel File.
One of the merge fields I have is "CC" which holds Clients Names + emails one after another eg
John Graham:John@Microsoft.com David Abbott:David@Hackney.com Steve Mcnamara Steve@Downs.co.uk
My challenge is to format the names in black & the emails in blue & underline them, without having to create multiple merge fields.