Hi !
I think I understood what need. This is a very interesting project.
I believe I can automate it. Although, I am not very familiar with VBA in MS Excel, this spreadsheet can be uploaded to Google Sheet, and I can do some script on Javascript (which I am more familiar with).
It would involve a two-part check for the critical items:
1) where there is only one email, and multiple names, the one with the highest rank would be addressed to;
2) where multiple emails, and multiple names, a similarity check would be done to determine who to pair with what email address (one or more email, I am guessing, might be matched.
Please drop my a line to discuss further. I would really like to take this chance to further my scripting skills. Thanks in advance !
Best regards,
Tristan