Mail Merge - Forcing new category to new page

[pol]

My data source is a table in Word, which consists of City, Employee, Sales. I would like to group by cities with corresponding employees and sales. For every new city I would like force this new category onto another document.

e.g.

To: Atlanta

Here are the total sales for the following employees:

Joe Smith 20000.00
Diane Taylor 35000.00

Please verify this.
-----------------------------------------------------------
To: Boston

Here are the total sales for the following employees:

John Thompson 10000.00
Mary Johnson 25000.00

Please verify this.

Could anyone help me with this issue?

 

[cjkoontz]

Was this one ever resolved?

I'm thinking that Crystal Reports is more better for this sort of thing than Word XP.

 

[dcompto]

"For every new city I would like force this new category onto another document."

Do you mean start a new document on a new PAGE? If so, see...

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

If not, so sorry!