trying to create vba to copy data when option button is selected

[steve400243]

Hello, on the attached worksheet I am looking for VBA to copy and paste to the body of an email - column A thru I, and any rows used, when the option button is clicked. A user would then input the email address to send. We are using outlook.
Then when the transfer to complete option is selected, transfer the data starting in A3 to I3 to the complete tab and auto saving for history. Then clearing all data starting in row 3 on the 1^st tab making the worksheet ready for the next user. Also the date and time listed in I1 like the example shown on the complete tab. Thank you in advance for all help.




also posted at - http://www.ozgrid.com/forum/showthread.php?t=204550