Auto add rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JethroUK - 12 Feb 2008 22:46 GMT

I have a merge from XL into a word table - 1 record per row (total about 5-6
pages)

Conventional mail merges are 1 record per page

The resulting merge will be used by staff and i want it as fool proof as
possible and i am not happy to ask them to open the main document, then
merge to new document to create the 5-6 page merge

i'm thinking of just creating a main document with 6 page already in it - so
they just open and print and close - but in the past i have noticed
discrepancies between records in main merge document and records produced
from merge-to-document - is this a good idea?

Reply to this Message

Doug Robbins - Word MVP - 12 Feb 2008 23:32 GMT

Use a Catalog (or in Word XP and later, it is called "Directory") type mail
merge main document in which you have a one row table into the cells of
which you insert the names of the merge fields. There must be nothing else
in the mail merge main document. When you execute that merge to a new
document, that document will contain a table with one row of data for every
record in the data source.

Signature

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

>I have a merge from XL into a word table - 1 record per row (total about
>5-6 pages)
[quoted text clipped - 9 lines]
> discrepancies between records in main merge document and records produced
> from merge-to-document - is this a good idea?

Reply to this Message

JethroUK - 14 Feb 2008 17:32 GMT

That's great thanks

> Use a Catalog (or in Word XP and later, it is called "Directory") type
> mail merge main document in which you have a one row table into the cells
[quoted text clipped - 16 lines]
>> discrepancies between records in main merge document and records produced
>> from merge-to-document - is this a good idea?

Reply to this Message