Hi.



I have created a word form that will be used for requesting annual leave, the fields will be completed and then emailed to a specific address, it will then have the remaining fields completed before being emailed back to the original sender. I have included two submit buttons on the form for these functions and have managed to find the code from researching various websites that attach the form to an email with the specific address and the authorise. however, i don not understand vba and need some help. when i send the form it does not save the completed fields unless i save first, is it possible to do this without saving the form as i want the original to remain blank? also is it possible to close the application on clicking the submit button so the user knows it has been sent? I then need the authoriser who has received the form and completes the remaining fields before clicking the authorise button that will then attached the completed form to an email before saving and closing the form to a specific location.

I hope someone can assist.

thank you in advance

Im using Word 2010 32bit & Outlook 2010

Might I suggest that a better approach would be to use a template, with code in it that forces the resulting document that is created from it to be saved to a particular location (folder), using information in the input fields for the filename? That way, there is no need for anything to be emailed to the "specific address".

Using a template obviates the issues of overwriting the base 'document' and Word's standard save & exit dialogues should provide sufficient notice to the end user as to whether their application has been submitted. Word's 'recent files' list should also evidence that the application was saved.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]