Right, I've got a simple address book in Excel 2010. 6 columns, Name, Address, Address, Town, County, Post Code. Each coloumn has these titles at the top.

I've gone into Word 2010, selected 'Start Mail Merge' selected the correct sized labels and created a correctly formatted sheets.

I then selected Selected Recipients and Use Existing, selected the correct Excel doc, then in the Confirm Data Source box, ticked the 'Show All' selected 'MS Excel Workesheet via DDE' then 'Entire Spreadsheet'

And on my label sheet in word each box just says 'Next Record' .....

Help? No idea what to do now to get my labels in the boxes in Word.

Only the first label will have the Name, Address, etc. in it. The 'Next Record' tells the merge to select the next record from your spreadsheet/database and insert it there.

Do a trial merge to a word document and you will see the correct information in each label.

HTH

Tom

Button on the end of the ribbon toolbar - Finish and Merge.

Cheers chaps