want to import excel cell data into word

[ZippyDan]

office 07

i have these avery labels
i have avery label template for word

i have an excel file with 2 columns of data (A and B)
each A and B column forms a pair (A3 + B3)

let's assume that A3 = "Blue" and B3 = "Cat" . for each pair, i need to make an entire sheet of labels, like so:

Blue
Cat

currently, i am creating the first label via 2x copy+paste, and then copy-pasting that label 31 times to create the page of labels. considering my excel spreadsheet has several rows, this will take a long time

what i'd like to be able to do is somehow reference or link excel cells within the word document, and then import. for example, i fill all the labels with the following:

<<A1>>
<<B1>>

then i hit some kind of import button and it gets replaced with

Red
Dog

i can then either change the contents of A1 and B1 to create my next sheet of labels, or i can change all the 1's to 2's to make

<<A2>>
<<B2>>

anyway to do this? mail merge looks almost like what i want to do, but i don't want to send a letter

 

[mayest]

Use mail merge (Mailings tab in Word 2007, then choose Start Mail Merge then Labels) with the Excel file as the data source. You need to have the Excel worksheet set up with labels in the top row and then the data in subsequent rows. Word will allow you to specify what goes where and also to filter the data if you want.