Trying to link Excel data to a Word label template (2010)

[K_furbs]

Hey all,

I'm trying to get a label template to auto-fill with data from an excel spreadsheet. The labels are formatted so they each contain several separate text boxes. They're warning labels for chemicals, similar to this one:



I need to make these labels for an inventory of around 550 chemicals. Obviously it would be ideal if I could somehow automate at least part of this. I know how to get an excel spreadsheet linked as an object in a word file, but is there any way I could use, for example, LOOKUP or VLOOKUP functions in a text box to get this information automatically?

Thanks for any suggestions, I'm not looking forward to manually entering 550 sets of numbers, manufacturers, and names like "Trans-(1,2- Cyclohexylenenedintrilo)-tetraacetate Acid"

- K