Ok here is what I am trying to do. I have worksheet #1 with a form that the user needs to complete. Sheet 2 is a list of email addresses that they can select from to send sheet #1 to. I want the user to be able to select the required people on sheet #2 to send it to by selecting a radio button beside their name and then click on a button to create the email.
The second this is I would like to copy and paste the sheet into the email rather than sending it as a file but this is not a must.
One other minor thing. There must be an easier way to put the check boxes in and align them rather than doing them on at a time and trying to move them one pixel at a time.
I haver included a sample of the workbook.
Bookmarks