All our letter templates open with a UserForm that the user populates; one of the inputs dictates if the letter is going overseas, which adjusts information within the template such as our telephone number (it adds +44 to the beginning of the number). One particular template then adds a “process document” using this code:
Code:
Documents.Add Template:="File Path\process document.dot", NewTemplate:=False
The “process document” provides details of what we are going to do and currently does not change; however, it does include several telephone numbers. I have now been asked to update the document so that the telephone numbers are amended dependent on where the letter is being sent
When this opens a UserForm appears and the user chooses one of two CommandButtons which will then amend the telephone numbers.
My question is, is it possible for the first document to launch the “process document” and then either select the appropriate CommandButton or to negate this stage altogether and update the “process document” without a UserForm?