View Single Post
  #1   Report Post  
 
Posts: n/a
Default 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