View Single Post
 
Old 07-04-2017, 04:51 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

If I was doing this, I would create an Excel worksheet that has columns with the names and their associated data and in the document a selection of content controls that correspond to the columns of the worksheet. I would then pop up a userform to select the name from the worksheet and insert the data into the various content controls as appropriate.

At its simplest would be the attached. Put both files in the same folder and create a new document from the template. Click in the first content control and you will see an example of what I mean.

Edit the worksheet as appropriate (don't change the columns without changing the code).
Attached Files
File Type: dotm Example1.dotm (41.0 KB, 30 views)
File Type: xlsx Addresses.xlsx (8.3 KB, 22 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote