mail merge for group mailing (labels) Microsoft Word 2002

[DruryLaner]

Hi, I am wanting to produce address labels using Avery product J8159. These come as 8 rows x 3 columns of labels on A4 sheet - which means 24 labels per sheet.

As my data source I am using an Excel 2002 SP3 worksheet containing the addresses of 50 people.

The mail merge works well, except that it is only filling one page of labels...i.e. in this case, the first 24 address records are being tranferred onto the label sheet, but not the other 26. I was hoping that it might automatically extend the label document so that all my records would fit. I can always get around it by splitting my records into groups of 24 each. But I hope there is a more streamlined way of dealing with the matter. Is there a setting somewhere that needs to be changed?

Any help most welcome.

[spacesurfer]

What seems like a problem is not really a problem. When you first mail merge, you won't see all the records. You only see the first page. But where you print, you will get all the pages, in your case 3 pages (24 + 24 + 2). Word handles it this way. A mail-merged document does not have a set # of pages because as you add records, the number of pages change.

Therefore, you can't just print say page 3 only. Word will make you print all the pages. If you have Adobe Acrobat, then print to that and you'll see all the pages.

If you don't, install the Document Write of Office and print to that.