Help with macro to save / email / close form

macropod · #2 04-20-2014, 06:44 PM

Quote:

Originally Posted by barters1972

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.

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".

Quote:

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?

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
a save-as prompt every time i try to close my session	willy0625	Word	5	01-08-2014 04:49 PM
Format of Header changing after save and close	shen_27	Word	4	03-19-2013 11:41 AM
excel 2010 not deleting tmp files on save/close	willbaker13	Excel	0	04-26-2012 05:08 PM
How to close an email account and save info?	Srcurran2201	Outlook	1	01-27-2012 07:09 PM
Auto Format Upon Save/Close	gamefish	Word VBA	1	12-08-2011 07:17 PM