mail merge, multiple records spread out over many pages

[ccmulllally]

Hi all,
I know this topic has received a fair amount of coverage, but I don't
know much about SQL programming and haven't been able to figures this
problem out.
I am trying to a mail merge where my data source is ordered by a
numeric identifier, each one representing a separate record. I want to
create a new document for each record rather than for every row. The
document looks like this:
------------------------------------------------page 1
numeric identifier: ________
question 1: ________
Table 1.
column1 column2
row 1
row 2
row 3
------------------------------------------------page 2
Table 2
col1 col2
row 1
row2
-----------------------------------------------------
etc, for 30 pages

This is a survey where I want to preprint some of the information,
such as some of the columns in the above tables. The document is all
written, and the data source is ready, but I haven't been able to
extrapolate from the examples online how I can do this. Any ideas? I
would greatly appreciate any help.

 

[Doug Robbins - Word MVP]

See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
at:

http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.


--
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, originally posted via msnews.microsoft.com