Another possibility, and one I tend to use myself, would be to create a lookup table of the users (see attached) which I would store in the same location as the template, to insert the required data in a content control (or controls) in the documents created from the template.
To see how this would work, put the template and workbook from the attachment in the same folder. Add your username, initials and phone number to the worksheet, then create a new document from the template.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
|