In a new column enter the formula =A5&";" where A5 is your actual first
record and the column that contains the email address. Then cut and paste to
email and Delete the semi-colon at after the last address.

"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!!