Yes. If your addresses are in Col A
then in B1 enter the formula
=A1 & ";"
and copy down to row 600 (double click at right bottom of B1)
Selct Col B and paste in Outlook address bar


"Ralkie" wrote:

I have about 600 email addressesn Excel database. I wish to send and emial to
all these emails. I know you can copy and paste the email addresses to the
address box. However, I have to put a colon (;) to separate the addresses.
Is there an easy way to go about this.