Need to Print Pages with Ascending Numbers

[MathewPankratz]

Hello,



I'm not very familiar with using macros or vba in word (fairly familiar in access and a little bit in excel, never in word, actually), and I have a situation where I print pallet placards that need to have bag numbers on them.

I need to print two placards for each pallet, so I need it to print two copies of each page before going to next number.

For some products it's as simple as having 1,1,2,2,3,3...

However, some have a bag range listed, ie 1-40, 1-40, 41-80, 41-80, 81-120, 81-120, etc.

I can't figure out the first step on this unfortunately. I have no idea how these work, but I'd like to figure it out, as it'd save my employees some time.

Any help would be greatly appreciated.

[macropod]

The simplest way of doing this would be to create an Excel workbook to use as a mailmerge data source. In the Excel workbook, you might have:
A1 'Bag No.'
A2 your starting #
A3 the forumula: =A$2+INT(ROW()/2)-1
and copy the formula in A3 down as far as needed. Save the workbook then, in Word, set the document up for a mailmerge using the Excel workbook as the data source and insert the «Bag_No» mergefield. If you then 'Finish' the merge, the merged output document will contain all your numbered pallet placards.