The right answer was given again by Kakesh. Congratulations!
If you have tabular data copied from Excel which contains a list of email ids, how to convert it to a semicolon delimited list for sending a mail. Of course, the quiz was to find the quickest and smartest way.
How to convert this…
email@example.com; firstname.lastname@example.org; email@example.com; firstname.lastname@example.org; email@example.com; firstname.lastname@example.org
The right answer
The answer is that you don’t have to do anything special.
Most email applications understand the issue and they know how to convert a tabular copy paste to a semicolon delimited list. In most cases, you don’t have to do anything special.
Just copy and paste the tabular data into the To, CC or BCC fields and click send as usual.
If you want to see the process in action, press Ctrl K or click on Check Names button in Outlook. It will process the data and show you the results.
I hope you already know this but just to be sure… If you are sending a mail to many unrelated people, put the names in BCC and put your own name in the To list. This way we protect the privacy of all the recipients.
Even though you may know all these people, they may not know each other. Therefore, it is your job to protect their identity.