Auto add rows

[JethroUK]

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?

 

[Doug Robbins - Word MVP]

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.

--
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

 

[JethroUK]

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
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.

--
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