FWIW, I'd be inclined to set this up using a label mailmerge with an Excel data source. In the workbook, I'd have a header row with columns corresponding to all the info you presently have to type. On the 2nd row, I'd type all those data and have formulae from rows 3 down that simply replicate the data from row 2. One column would be for the Carton # and another for the number of cartons. Unlike all the other columns, the Carton # columns would simply increment from the row above, I might have, say, 100 rows of data set up this way. Having filled in the data on row 2, I'd save & close the workbook, then open up the Word mailmerge main document, answer 'yes' to the mailmerge SQL prompt, then click 'Finish & Merge'>'Send to Printer' and tell it to process records, say, 1 to 80 (80 being the # input into the workbook column for the number of cartons). No copying & pasting label content is required with such an approach.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|