Jasper
|
| posted on 2/9/10 at 02:16 PM |
|
|
Help with Mail merge and label printing please
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.
If you're not living life on the edge you're taking up too much room.
|
|
|
|
|
se7en
|
| posted on 2/9/10 at 04:28 PM |
|
|
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
|
|
|
McLannahan
|
| posted on 2/9/10 at 07:12 PM |
|
|
Button on the end of the ribbon toolbar - Finish and Merge.
|
|
|
Jasper
|
| posted on 3/9/10 at 12:37 PM |
|
|
Cheers chaps 
If you're not living life on the edge you're taking up too much room.
|
|
|
