Creating an email list
 

I have a column of email addresses, and I want to combine them all into one
cell seperated by commas. I want to make an group email list that I can just
copy into an email without having to enter each individual emaill address.

Creating an email list
 

Say your email list is in column C starting in C1. In D1 enter "=C1"
without the quotes. In D2 enter =D1&","&C2. Drag this formula down as far
as your email list goes. The last cell will show all the emails. HTH Otto

"ILunacy" wrote in message
...
I have a column of email addresses, and I want to combine them all into
one
cell seperated by commas. I want to make an group email list that I can
just
copy into an email without having to enter each individual emaill address.