I have a challenge...
I have an 8 page "Certificate" that will only need two
pieces of variable information. First is the serial
number (i.e. 30328765). There are about 15 of these
serial numbers that could be typed in. Second, depending
on the serial number that is typed in, I need to pick up
data from a similarly-named worksheet in an Excel file.
For example, if I type "30328765" into the Word document,
I also want the data table on an Excel worksheet
named "3032876" to be included in the Word document.

Any help you could send my way is greatly appreciated.
Lyndie