mail merge with 2/3 keys? cant get page break

[Lisa274]

I am stumped. I have read the Catalogue Mailmerge Tutorial and I need to combine most all of your posts but when I do I get the wrong results. I really have tried. If I knew a place to find the sytnax of the language it would help tremendously.



What I need:

logo.jpg
letterhead

<emp name>key 1 - emp name
<address>
<city>

These are the benefits for <emp name> and any listed dependents:

Benefit Name<tab>Employee Per Pay Cost<tab>Benefit Amount
<Benefit Name>tab<cost>tab<benefit amount>key 2 - Benefit code
tab<dependent name>
tab<dependent name>
tab<dependent name>
<Benefit Name>tab<cost>tab<benefit amount>
tab<dependent name>
tab<dependent name>
tab<dependent name>
<Benefit Name>tab<cost>tab<benefit amount>
tab<dependent name>
tab<dependent name>
tab<dependent name>

<new page for different employee>
========

* when I add the QUOTE 12 it gives me an error code OR it does a page break before each Benefit Name (I believe I am using the proper syntax)
* Do I need a 3rd key to sort
- by employee name
- by benefit code
- list of dependents

I need to combine your
Merge Records using Two Keys
Force each new category to a new page
Insert Content Data before repeated data (mine repeats before every new benefit (so I took it out of the code) - but I need it to be before the FIRST benefit - blue above)

The mail merge will produce thousands of letters. The data is from an access database since we had to combine two spreadsheets.

It *IS* a DIRECTORY merge
I *do* have the file sorted:
Emp Name
Ded Code (The Benefit Name and Dependent all share the same Ded Code)
Dependent Name

I have attached 2 files.

Your assistance is appreciated.

Lisa