"jgkocis" wrote...
I have a list of about 1,500 email addresses. To send an email I need
to have a comma between each entry. I know I can use the formula
=(A1&,",",&A2) to concatenate cells A1 and 2, with a comma between the
2 strings, but is there a formula to automatication do it for A1 -
A1500???

Or is there an entirely different approach I should consider?

Junk mail, aka spam, is about the only thing I can think of that would
benefit from concatenating 1500-odd e-mail addresses together into a
comma-separated list. If that's your intent, then answering your question
would worsen the quality of life (or time spent on the internet) for the
rest of us.

That said, all e-mail programs I'm familiar with provide facilities to
create groups which could be used in To, cc and bcc fields. Why are you
making this so difficult trying to do it in Excel?