Adding commas "," in email addresses for sending BULK Email stored cellwise..!

Dear Forum,

I have around 200-250 Email addresses in an Excel Sheet and I need to send BULK Email to all these email addresses, however typing the same manually is tedious and time-consuming as its a regular activity every week-end.

Is there a way by FORMULA or VBA whereby I could get all these email addresses in a single cell with commas in between each email address after the first and just before the last email address in the range.

Warm Regards
e4excel