I have inherited a spreadsheet with a column for e-mail addresses.

I need to combine all of the addresses to send a single e-mail to each
person in the list.

I have tried conctenate and copy down the column thinking it would be
cumulative, but it doesn't seem to work. I think I am messing up the formula
somewhere. Any help would be greatly appreciated. Here is what I had tried:

=CONCATENATE(P2,"; ",P3) then I copy down the column.