Copy Cells & Paste into active window

1st Issue: I have a sheet, that when I click on the "TSA Request" button it launches a lync window to a group in my office. What I want it to do is when I click on the button, it copies cells A1:I12, pop open the window from Lync & paste the copied info into that window. I tried using the lync macros I found on the internet but we don't have access to the SDK files so this is the only solution that I have a possible fix to.

2nd Issue: I would like when I click on the "Manual Move Request" button, I would like for it to look at Cell F17 and find that name (Sheet(Employees).Range "C + B" to match the name and put the email for that person from cell in column U.

I have attached my workbook so you can try it for yourself. Thank you for any help in advanced.

Well Lync is a Microsoft application that was replaced with Skype for Business! All of the names are on the Employees sheet (Look in columns B & C at rows 995-1001! Correct it puts the data correctly - however I want it to look up the names from F17 on sheet "Employees" & then pull their email and put it in the CC in the macro.

Their email address are in Column U on the Employee Sheet

Basically it would see who's name is on sheet "TSA Request" in cell F17 and then find that employee from sheet "Employees" when you put the names together from C + B and then looks in column U and gets their email to put in the CC line of the email macro.

Example: F17= "Ray Webber", it would look for Ray on Sheet(Employees) in the C column & then Webber in the B column and return the results of rwebber@****.com and insert it in the CC line on the email!

Correct - this is just a sample - I will add the correct names at a later date - I just need it to do as I am requesting

Perfect - Thank you so much for your help with this!

So I ran into a problem - there are 3 names that it is not finding and putting in the CC of the email. Dialo Lee, Joel Gonzalez & Micheal Harrison. Any ideas of why its doing 4 name but not the other 3?

Perfect - Thank you! Now about the 1st issue - are you comfortable with copy the Range from A1:I12 to copy and it opens an IM in Lync then paste the info? By what I have read on the internet we need to call a .dll file and since I dont have access to those files, can we do a coy and paste in active window after the hyperlink to open a new IM to a group?

Yeah I looked and didnt see anything - I am trying to make this simple as possible as it will be given to every agent (>300) people to use and rather have 1 excel sheet rather than a folder of files to call.