Attach Cell URL

Hi All,

Im trying to create an excel form that has a "email" button that automatically attaches the spreadsheet and send its.

I have this part working, but what i would like to do if possible is make the code also select the file addresses that have been placed in certain cells and attach those files to the same email. (ideally I would love this to be a drag and drop procedure, but I can get that working, so opted for a button that simply open a window to select the file than pastes the location in a cell)

Can anyone help