Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Complex Mail Merge using Directory Document Source
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
How to protect the main document in a mail merge process | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Mail merge source document hangs on opening | Mailmerge | |||
How do I print a mail merge data source without the main document | Mailmerge |