I have a list of e-mail addresses in an Excel spread sheet. How do I copy that list into my e-mail TO: line?

There are a couple of ways, but I find this quite easy without having to copy the list out to Word or Notepad.

Let's say your list of email addresses is in column A, from A1 to A50. In any other cell, type:

=CONCATENATE(TRANSPOSE(A1:A50 & ";")

DO NOT PRESS ENTER YET!

While still in edit mode, select TRANSPOSE(A1:A50 & ";")

With that selected, press F9.

You will see something like =CONCATENATE({"email1@gmail.com;", "email2@yahoo.com;"})

but much longer, with all email addresses in the list. Now, delete the curly brackets { and }.

Press ENTER.

Now you have a list that you can copy and paste into the TO: field. Most email clients use the semicolon as a separator. If yours uses anything else, such as a comma, replace the ";" part of the formula above with "," or whatever separator is required by your email client.

There are also VBA solutions that can send an email to every (or selected) addresses in the list, and these are easy to find.