[Dr_Cammo]

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

[Doug Robbins - Word MVP]

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

[Dr_Cammo[_2_]]

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