Concatenate long list with punctuation (email list)

anyone know how I can concatenate a whole column of email addresses into a single cell with "; " (semicolon space) between each email? I want users -- who are mostly unfamiliar with excel and from a variety of organizations (so I can't do a distribution list) -- to be able to use the most up to date list of members and grab all the emails from one cell (so I can't do a distribution list) and copy/paste it into the outlook send box.
They likely won't understand they can select the column, copy, and paste it because it will look so odd in the send box. I want them to feel safe and comfortable doing it.
The only solution I can find is =concatenate(d5,"; ",d6,"; ",d7,"; ",etc to d45) which would take forever to type in AND wouldn't automatically add in any new members to the list (because d46 isn't in the function).
Is there a better way to do it? (I don't mind doing a series of functions in the background, as long as the cell visible to the group has the complete list of emails).
Thanks!