Help Sort by Category with Table

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Steve (mrcvn_at_hotmail.com)
Date: 07/28/04


Date: Wed, 28 Jul 2004 12:09:24 -0400

I have used the below guidance to set up a mail merge to force a new
category to a new page, it work fine in the example for standard tab format.
However, I have six fields to pull data from (Excel File), two of the fields
contain long sentences (Title & Resolution Action). So I need to use a
table to hold the data in columns or it just runs wild on the page. I can
make it work for directory as a single list but I am at a loss to make it
page break for new categories. Is it possible to use a table format and
page break on categories?

Steve

      «Action_ID»
     «Title»
     «Planned_Start_Date»
     «Planned_Finish_Date»
     «Percent_Complete» %
     «Resolution_Action»

Microsoft Knowledge Base Article - 211303
HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2000

City Employee Sales
   Atlanta Smith $3,000
   Atlanta Gates $50,000
   Atlanta Henderson $10,000
   Houston Jones $8,000
   Houston Kelley $9,000
   Houston Peterson $0

Force Each New Category to a New Page
{ If { MERGESEQ } = "1" "{ MERGEFIELD City }" ""}<ENTER>
{ SET Place1 { MERGEFIELD City }}<ENTER>
{ If { Place2 } <> { Place1 }"<ENTER>
----------------------------Page Break--------------------------------
{ MERGEFIELD City }<ENTER>
<ENTER>
{ MERGEFIELD Employee }{ MERGEFIELD Sales }" "{ MERGEFIELD Employee }{
MERGEFIELD Sales }" }{ SET Place2 { MERGEFIELD City }}<ENTER>

Atlanta

Smith $3,000
Gates $50,000
Henderson $10,000

----------------------------Page Break-----------------------------
Houston

Jones $8,000
Kelley $9,000
Peterson $0