Pull multiple emails for location & insert into email

So I have a sheet called "TSA Request" where my employees fill in the data. On the sheet called "employees," I have a list of all of my employees with their emails & the location they are at. When I click on the button called "Manual Move Request, I want it to generate an email to the location using everyone's address at the facility with the subject line of "SSC Manual Move Request:" (with the Customer Number from the sheet). Any help would be greatly appreciated. This is the code that I have for the email but its still a working progress. This is the formula I was using to display a email but its only one from the location.

Please Login or Register  to view this content.

I also have a button thats called "TSA Request", when I press this button it opens lync to a group but it does not copy any info over to it. Is there a VBA code that we can run so when I click on "TSA Request" it would extract & send the data to the recepients in Lync? Here is the hyperlink to send it to the agents.

Please Login or Register  to view this content.

Just wanted to follow up and post the answer here. After playing around with the formula for a while, this is what I came up with!

Formula:

Please Login or Register  to view this content.