Pallet Labels

I have an Excel file I need to merge into word containing a customer name and
number of pallets (eg. 3). Is there a way of using the number of pallets
field to create the following. "Pallet 1 of 3", "Pallet 2 of 3" and "Pallet 3
of 3" before moving onto the next customer.

Thanks for assistance

If you are only merging the number of records that equate to the number of
pallets, you could use the Merge Record # field to get the 1, 2 and 3

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Dr_Cammo" wrote in message
...
I have an Excel file I need to merge into word containing a customer name
and
number of pallets (eg. 3). Is there a way of using the number of pallets
field to create the following. "Pallet 1 of 3", "Pallet 2 of 3" and
"Pallet 3
of 3" before moving onto the next customer.

Thanks for assistance

Thanks Doug....Almost there.

I'm after something as follows.

Cust 1 - 1 of 3
Cust 1 - 2 of 3
Cust 1 - 3 of 3
Cust 2 - 1 of 2
Cust 2 - 2 of 2
etc

Thanks

"Doug Robbins - Word MVP" wrote:

If you are only merging the number of records that equate to the number of
pallets, you could use the Merge Record # field to get the 1, 2 and 3

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Dr_Cammo" wrote in message
...
I have an Excel file I need to merge into word containing a customer name
and
number of pallets (eg. 3). Is there a way of using the number of pallets
field to create the following. "Pallet 1 of 3", "Pallet 2 of 3" and
"Pallet 3
of 3" before moving onto the next customer.

Thanks for assistance