We are trying to do a mail merge. Its a wee bit difficult to explain
so please bear with me. Basically, we have a number of orders with
one
or more items contained there-in, those order numbers that have more
than one item are generated on a seperate mail merge document when
we'd prefer them to be on the same one.

For example:

Order 1 - 1 item   - Order number is 001 (Only one mail merge
document
is created, but --->
Order 2 - 4 items - Order number is 002 but there are four rows with
the item details & order number, these appear separately over 4
merged
documents, we'd like one merge document for order number 2 showing
details of the four items.

There are about 80 odd orders but over 600 items. So instead of
having
80 merged documents we get 600, one for each seperate item.

I tell you what, if you can understand that, you'll have no trouble
solving it for me.

Got a headache now... :-)

Any help gratefully appreciated

Thanks