Help Sort by Category with Table
From: Steve (mrcvn_at_hotmail.com)
Date: 07/28/04
- Next message: Mark Avis: "Mail Merge Database Error"
- Previous message: Wes Dabney: "Automated Merge from command-line"
- Next in thread: Doug Robbins: "Re: Help Sort by Category with Table"
- Reply: Doug Robbins: "Re: Help Sort by Category with Table"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Mark Avis: "Mail Merge Database Error"
- Previous message: Wes Dabney: "Automated Merge from command-line"
- Next in thread: Doug Robbins: "Re: Help Sort by Category with Table"
- Reply: Doug Robbins: "Re: Help Sort by Category with Table"
- Messages sorted by: [ date ] [ thread ]