Hello,

I have a client who wants to perform a merge that repeats rows on
different pages, but with different headers at the top. And the header
has some of the fields that are repeated as well. Here is an example
of what it needs to look like:


A/E SELECTIONS FOR GROUNDBREAKERS BY EXECUTIVE DIRECTOR
=ABField64=BB BOARD MEETING

CDB PROJECT # SELECTED A/E
PROJECTS P.M. PROJECT TITLE/LOCATION A/E I.D.#
__________________________________________________ __________
=ABField3=BB-=ABField4=BB-=ABField5=BB =ABField73=BB =ABField6=BB =
=ABField64=BB
=ABField61=BB =ABField59=BB =ABField74=BB
=ABField75=BB

Now everything below the line needs to repeat down the page, until the
data in Field 64 changes. So, if the data in Field 64 remains the
same, the Fields 3 through Field 75 repeat with different data down the
page. I typically use the Directory document type for this, but the
problem is getting stuff in the header to perform the Next function,
because Next or If functions don't work in Headers.

Any suggestions?

If anyone wants an example of this type of document, I can send you a
copy offlist. =20

TIA,
Jason

Word does not really have the ability to perform a "multiple items per
condition (=key field)" mailmerge.

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindy...r/MergFram.htm

Or, if you create a Catalog (on in Word XP and later, it's called Directory)
type mailmerge main document with the mergefields in the cells of a one row
table in the mailmerge main document with the keyfield in the first cell in
the row and then execute that merge to a new document and then run the
following macro, it will create separate tables with the records for each
key field in them. With a bit of further development, you may be able to
get it to do what you want.

' Macro to create multiple items per condition in separate tables from a
directory type mailmerge

Dim source As Document, target As Document, scat As Range, tcat As Range
Dim data As Range, stab As Table, ttab As Table
Dim i As Long, j As Long, k As Long, n As Long
Set source = ActiveDocument
Set target = Documents.Add
Set stab = source.Tables(1)
k = stab.Columns.Count
Set ttab = target.Tables.Add(Range:=Selection.Range, numrows:=1,
numcolumns:=k - 1)
Set scat = stab.Cell(1, 1).Range
scat.End = scat.End - 1
ttab.Cell(1, 1).Range = scat
j = ttab.Rows.Count
For i = 1 To stab.Rows.Count
Set tcat = ttab.Cell(j, 1).Range
tcat.End = tcat.End - 1
Set scat = stab.Cell(i, 1).Range
scat.End = scat.End - 1
If scat tcat Then
ttab.Rows.Add
j = ttab.Rows.Count
ttab.Cell(j, 1).Range = scat
ttab.Cell(j, 1).Range.Paragraphs(1).PageBreakBefore = True
ttab.Rows.Add
ttab.Cell(j + 1, 1).Range.Paragraphs(1).PageBreakBefore = False
For n = 2 To k
Set data = stab.Cell(i, n).Range
data.End = data.End - 1
ttab.Cell(ttab.Rows.Count, n - 1).Range = data
Next n
Else
ttab.Rows.Add
For n = 2 To k
Set data = stab.Cell(i, n).Range
data.End = data.End - 1
ttab.Cell(ttab.Rows.Count, n - 1).Range = data
Next n
End If
Next i


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
wrote in message
oups.com...
Hello,

I have a client who wants to perform a merge that repeats rows on
different pages, but with different headers at the top. And the header
has some of the fields that are repeated as well. Here is an example
of what it needs to look like:


A/E SELECTIONS FOR GROUNDBREAKERS BY EXECUTIVE DIRECTOR
«Field64» BOARD MEETING

CDB PROJECT # SELECTED A/E
PROJECTS P.M. PROJECT TITLE/LOCATION A/E I.D.#
__________________________________________________ __________
«Field3»-«Field4»-«Field5» «Field73» «Field6» «Field64»
«Field61» «Field59» «Field74»
«Field75»

Now everything below the line needs to repeat down the page, until the
data in Field 64 changes. So, if the data in Field 64 remains the
same, the Fields 3 through Field 75 repeat with different data down the
page. I typically use the Directory document type for this, but the
problem is getting stuff in the header to perform the Next function,
because Next or If functions don't work in Headers.

Any suggestions?

If anyone wants an example of this type of document, I can send you a
copy offlist.

TIA,
Jason