Good Morning, I was looking for a little help, I have a system in work whereby you "Match" with another colleague.

The data is presented to me in Column 1 being one email address, Column 2 being the next email address. I tried to concatenate the email addresses then use a mail merge to send to each "pair"

However this didn't work as it says MS Outlook doesn't recognize the emails with a semi colon in the middle.
Does anyone know a way around to send the same email to different pairs of people?

Thank you