You could add a helper column with =A1&";" and copy down.

Copy/paste as values and use that for your address list.

Or.....................

Visit Ron de Bruin's site to learn all you will ever need about emailing
from Excel.

http://www.rondebruin.nl/sendmail.htm

Download the SendMail add-in to make life easy.


Gord Dibben MS Excel MVP

On Mon, 27 Oct 2008 09:52:02 -0700, BVZ
wrote:

So I have a list of over 1500 people in my database and they all have email
addresses. I want to send an email to all these people so I copy and paste
them in to the "to" field in my email. Well it takes them out of excel and
puts them in there just fine but it only has a space between the email
addresses and not a comma or semi-colon. Is there any way to write a rule in
excel that says to put a comma or semi-colon on the end of each email
address?

Please help, I really do not want to sit there and put semi colons inbetween
each email address... That would take FOREVER!!