I'd use this.

Insert a new column to the right of the email address column.

I'm gonna use A for my email column and B for my new column.

Put this in B1:
=A1
put this in B2:
=B1&";"&A2
(Change the separator to what you need)

And drag down the column.

Copy that last cell and paste into your email to: field.

Lizizfree wrote:

I too have a list of email addresses in one column and would like to insert
all addresses into one email for a mass mailing, is it possible to do without
copy and pasting each email address in one at a time?

--

Dave Peterson