Automating Excel Form Sending

[scottkiely]

Is there any way I can copy a simple form from excel which we are currently using in my workplace and save the form as a template (each manager has their email address saved, so making a different template for each manager).

I can copy the form over, but I lose formulas, anyway I can keep formulas?

OR



If I could JUST show the top half (emplyee details) and hide the carbon copy sort of thing for the receipt, and have the second half sent to the employee and the top half sent to the manager?

Hols.xls