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

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:

label10a.jpg

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

Hi K

The good news is that there is no need to use formulas, lookups or the like. The bad news is that I have no experience of getting graphics into Word (the blocks at the top, the diamond motif) nor the barcode. (I have just tried, but without success. Perhaps you should try a MS Word forum? )

To get words into Word, you need to go to Word and from the mailings tab select labels. Then set up a mailmerge, using the excel sheet as your source. I have used this for mailing labels and it works well.

I hope that this points you towards a way forward

Regards
Alastair