Mail Merge Woes...
 

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

Mail Merge Woes...
 

I don't believe this can be done with Mail Merge. I think it will require
some VBA in Word to achieve what you want.

Have you posted this on the WORD newsgroup?


"pa_broon74" wrote:

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