In Word 2007 how can I set up a repeating section for Mail Merge

Question

In Word 2007, I want to set up a mail-merge template where multiple rows from the data-source will appear on a single page. So, something like this:

---Page-Boundry--------

  Header blurb 1
  Header blurb 2
  Header blurb 2

  ---Mail-Merge-Repeating-Block--------

   <<Merge Field 1>>, <<Merge Field 2>>
   <<Merge Field 3>>

  ---End-Mail-Merge-Repeating-Block----

  Footer blurb 1
  Footer blurb 2
  Footer blurb 3

---Page-Boundry--------

Its the "Mail-Merge-Repeating-Block" bit that I'm stuck on. If I just set up a standard mail merge with the header blurb, the merge fields and the footer blurb I get one page per row, with each page showing one row in between the header and footer. What I need is one page of output with multiple rows in between the header and footer.

One side note: I'm configuring the merge fields manually, I'm not using the wizard because I don't have direct access to the data source. The template I'm setting up will be stored in a custom business application that actually does the merging.

Answer 1

You'll need a <> field after each row of the data source EXCEPT THE LAST ONE ON THE PAGE.

If there is any way humanly possible to get that data source pre-processed to a temp file that has all of your data in one record it would help you a lot in the long term.