Hi,
My workbook has a test/assessment on it. I want the user to be able to email their results to their line manager once they have completed it by just simply pressing a button.

- the results will be on 'Sheet2' in cells A1 - C26.
- i want the user to be able to select their line managers email address by using the outlook address book
- i dont want the user to be able to see the results of their test/assessment in the email body (as this is for the line manager to discuss the results at a later date).

Is this atall posible?
can anyone suggest a solution for me?

very much appreciated
Lee