Word 2003 1 Page per person Label Mail Merge

[PCmad]

I have been looking at the new mail merge in Word 2003 and cannot seem to find a way to do what I require. I have an excel sheet with the source data containing say name, company, address 1, address 2 etc and have say 60 rows of information or 60 records. I am using A4 Avery labels L7160 selected by A4/A5 option.

I want to merge so that page 1 is a whole page of the first record, page 2 is the second record and page 3 is the third record and so on. For example if on page 1 there is room for 15 labels I want 15 of Record 1 on page 1. Then Page 2 another 15 labels for record 2 and so on.

I can get a whole page of say record 1 on page 1. But on page 2 I have to manually enter an insert field of <next record> on all 15 labels on page 2. Then when merged then puts page 1 as I want and then page 2. But to do this I have to manually on each page insert the field <next record> and copy it on each page. If I have 60 records or 60 pages this is very time consuming.

I can get a mail merge no problem where on page 1 the first label on the page is record 1, then next record is 2 on label 2 and so on no problems. But I do not want this. It must be 1 label per page, then change on page 2.

When I use the wizard I get as far as inserting my fields, but it automatically puts next record all down the page apart from label 1 and I have to delete next record from all the labels.

I hope this makes sense and sorry for the long post. Any ideas, its driving me crazy! It never use to be this hard in version 2002 or version 2000, help!

 

[dcompto]

I don't have Word 2003, but I have seen documentation that indicated you can get the "old merge toolbar that was used in earlier versions" by doing the following:

Click down-arrow at the extreme right of the merge toolbar
Select add or remove buttons
The missing command is unchecked at the bottom of the list
Check it, then select customizeand drag it to a position on your toolbar

HTH

 

[modglin]

PCMad - We have recently upgraded to 2003 as well and have experienced a few problems. You may be able to help with a problem we have.You indicated you see lables 1-20 on one page. When we do this, we get 1-20 on one page, and then 2-21 on page two and 3-22 on page three and etc. How did you set yours up so that it flows without repeating any? I will also look at the file setup that we have and see if it might help lead to resolving your problem since it does repeat part of them again.