Email to list sat up in Excel
 

I have entered about 500 email addresses into Excel spread sheet, how do I
merge these into a email so I can send this out in groups of 50?

I know they have to be separated with commas but I do not remember how to do
this. Please give step by step I am very slow with a computer

Thank you
Linda

Email to list sat up in Excel
 

Assuming that your first e-mail address is in cell B2, type the formula in
cell C2: = A2 & ", "
Copy this formula down your range up to cell C501 or sos. Now, column C
contains e-mail addresses followed by a comma, and you can "take" them 50 by
50 with a mouse selection, copy and paste in your e-mail address bar.

Email to list sat up in Excel
 

Stephane thank you very much for helping me with this question.
Linda

"Stephane Quenson" wrote:

Assuming that your first e-mail address is in cell B2, type the formula in
cell C2: = A2 & ", "
Copy this formula down your range up to cell C501 or sos. Now, column C
contains e-mail addresses followed by a comma, and you can "take" them 50 by
50 with a mouse selection, copy and paste in your e-mail address bar.

Email to list sat up in Excel
 

Stephane, this worked perfectly when I used this formula in July. However I
am encountering problems using this same formula. please let me know if my
email address is in e2, would the formula not be =e2 & "." I do not know why
you said to use A2 in the formula listed below.

Can you let meknow.


"Stephane Quenson" wrote:

Assuming that your first e-mail address is in cell B2, type the formula in
cell C2: = A2 & ", "
Copy this formula down your range up to cell C501 or sos. Now, column C
contains e-mail addresses followed by a comma, and you can "take" them 50 by
50 with a mouse selection, copy and paste in your e-mail address bar.