We have a winner

The right answer was given again by Kakesh. Congratulations!

image

The question

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…

image 

to this…

someone@maxoffice.biz; boss@maxoffice.biz; finance@maxoffice.biz; chairman@maxoffice.biz; everyperson@maxoffice.biz; katrin@maxoffice.biz

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.

image

Email etiquette

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.

One thought on “We have a winner

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s