View Single Post
 
Old 03-31-2015, 10:49 PM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,142
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

The best way to do this is to create a simple userform http://www.gmayor.com/Userform.htm which collects the variable data and inserts it into the required places in the document using bookmarked locations. You will find a handy function for filling bookmarks with values from the userform at http://www.gmayor.com/word_vba_examples.htm

Variable data can be read from a data source (or sources), ideally Excel worksheet(s), or it can be typed into a text field. The examples in the first link used typed data. For more on filling list boxes from external data see http://www.gmayor.com/Userform_ComboBox.html
__________________
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