mail merge with 2/3 keys? cant get page break
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
Last edited by macropod; 01-05-2014 at 01:18 PM.
Reason: Invalid image & reference to it deleted
|