If the two names are related, as appears to be the case, both names need to be in the same record of the data source. It is by far the simplest option to add another field to the Excel data source.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
|