Here you go happymouth,
An updated version - it now has an extra button on the form. Your options are now:
- OK - Enter the form data and close the form (allows you to manually edit the form before printing - just in case)
- Clear - clear the data from the form, but keep it open (In case of mistakes)
- New - enter the data from the form, print the document, clear the data from the letter and form (so you can do multiple letters in one sitting)
- Cancel - Closes the form and the document [NOTE: IT DOES NOT SAVE THE DOCUMENT, NOR ASK TO] (for when you have finished)
As before - open and then save as a Template (this puts it in your Templates folder)
If you look in the coding, I have annotated each section for you, so that you can decipher it easier. There are two sections of code - one in the form itself, the other in 'This Document' - look for both in the left-hand explorer window in the VBA Editor.
Hope this helps!
ERROR: THE (v2).doc VERSION CONTAINS AN ERROR IN THE VBA CODING - PLEASE ENSURE THAT YOU HAVE THE *(v2.1).doc VERSION