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?

 

[JerryDennison]

I guess I'm not quite following you. Are you using Access to generate the report of another Word document? If Access, how are you linked to the Word table? If Word how are you linked to the other Word table?

In either case, by default if you merge to new document it will create a new page for each record. What is it doing now when you merge to new document or to a printer?

 

[pol]

I formerly used an Access database, but I now have it as a table in Word. And I am using the data from the table to merge with another Word document. Here is a sample of the data which appears like this:

CITY EMPLOYEE SALES
Atlanta Joe Smith 20000.00
Atlanta Diane Taylor 35000.00
Boston John Thompson 10000.00
Boston Mary Johnson 25000.00

I wanted to group all the employees and their sales for Atlanta and put them on one document, and all of Boston on one document, etc.