I understand the problem was to have a mail merge documents with the recipients of each line to go to more than one address. This could be for the reason that a letter about a client could go to a manager as well as the worker, and the next letter goes to a different worker and different manager.
As you have found out, the semi-colon separater does not work. Now I am no expert with VBA so I thought about this problem.
The mail merge looks at the whole address, semi-colon and all. And of course, the email of this 'compound address' does not exist. The semi-colon is not recognised as a separator.
So how do you do it... Easy...!!
For each 'set' of email recipients you need to create a 'mailing list' in Outlook. So to email Bert@email.com and Agnes@email.com you would create a mailing list of both email addresses and call it, for example 'Bert and Agnes' (without the quote). Likewise for Bert and Joyce, create a mailing list containing both names.
Then in the merge cell (Excel or whatever), insert the names you have created for the each mailing list. So the merge cells containing the email address, one would contain 'Bert and Agnes' the one underneath 'Bert and Joyce' (again without the quotes). Then Outlook will look up these names from the mailing list and one email would be sent to both Bert and Agnes, and another one to both Bert and Joyce, etc.
And it does work!
Hope this helps, sorry if it is a long time in being posted, I've only just come across the problem myself.
Regards
Mervyn