Hi, Im hoping someone can help me.

I have a selection of word documents embedded into excel 2010. I would like the end user to be able to select either one item or several and them copy them to outlook as Microsoft Word documents (Attachments)

I have attached a photo mock up of the spreadsheet as I cant upload from work but the finished Item will have 8 embedded word documents to select from. I images of word documents instead of embedded objects due to file size.

Object Select and Email.PNG

Can someone please let me know if this is possible and help me with code, as this is all I have at the moment.
Sub Copy_Object1()
    ActiveSheet.Shapes.Range(Array("Object 1")).Select
    Selection.Copy
End Sub
Thanks