Congratulations Mr. Pratyush Nayak for winning the quiz. Amazing performance – he got all the right answers in just 5 minutes and 3 seconds. What is even more commendable is that he got all answers right in the first attempt!
Mr. Pratyush please send me a mail at email@example.com. Office Mix does not reveal your contact details.
Read on to find out the right answers and learn more … Continue reading
Congratulations Pranay Mehrotra for getting all answers right with minimal attempts and faster than everyone else. You will receive your voucher by mail. Please send us your email id on firstname.lastname@example.org. Kamal Karnatak was the fastest to solve the quiz.
However, he replied after the published Quiz ending time.
Questions, Answers and Related Articles
This is not just an announcement. It is a reading list as well.
You can learn more about each topic by clicking on the related article link.
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.