Send sheet as Outlook attachment

Hi,

Could someone please help me with this? I have compliled a form that staff need to fill out to provide notification of visitors using Excel 2003.

The idea is that details are entered onto the form and then emailed to the department concerned. Once the email has been sent I need the original details on the worksheet form to be cleared in readiness for the next user.

I've attempted to put together a macro to do this and tried various ways to get it to do what I want, but to no avail - please see attached file.

Any help or advice would be greatly appreciated.

Thanks