That's the problem. Basically what we are doing is an employee fills out
their timesheet. They pick an email address in the drop down box. The hit
the submit button. It emails it to the person in the dropdown box.

The person receives the email. They open up the excel file and type in a
box whether they approve or disapprove of the time card.

When they hit submit, they get an error.

What I need is for the approvers to hit submit and it email to payroll so
they can be paid.

What about a second submit button for approvers only? Can you think of a
workaround of some sort?