On my excel file, I have a button which opens up a user form with editable fields.

On this user form I have a 'Submit' command button. When this button is pressed, whatever is entered into the fields on the form is the inputted into cells on my worksheet.

I would like, as this 'Submit' button is pressed, for it also to populate fields on a word doc then attach the doc to an email and send it to a pre-defined email address. The email address will be the same every time.

I am using Office 2003.