Vba For Multiple Addresses Via Range

I'm trying to draft together a simple VBA script or even =HYPERLINK string to utilize a range of cells in Excel for the To: field in an Outlook email.

I have 7 columns each with categorized for different individuals in different departments.

Instead of dealing with contact groups, I have created a spreadsheet that breaks down the departments and supplies the email address for everyone in the department.

So, what I want to do is make a link or button for each group that when it is clicked on will open a new email via outlook with all of the addresses in the appropriate range in the To: field.

Example:

Cell: A1 is the heading
Cell: A2 is the link/button you would click on
Range: A3:A255 would contain the addresses.

One other thing, I'm not positive if this is an issue or not...The script might need to add the customary semicolon and space after each address added to the To: field...As needed when using multiple addresses in Outlook.