Next record if

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mail Merge 'Next Record If' - 06 Mar 2006 20:47 GMT

I am downloading emp personal data from another system into Excel for our
employees to verify. I am running into problems with the dependents section
which can vary depending on how many dependents are listed. The Excel ss
shows 5 records for one emp while the next only has one. How can I get the
merge to understand that when the clock number changes to go to a new form?
The rest of the form works great but this is driving me nuts! I believe it
has something to do with the 'next record if' word insert but can't get the
correct syntax. It keeps merging the same number of dependents for each
record (page) and grabs the next available dependents to 'fill up' the
section.

Thanks for any help.

Reply to this Message

Doug Robbins - Word MVP - 07 Mar 2006 20:37 GMT

You are trying to perform a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am downloading emp personal data from another system into Excel for our
> employees to verify. I am running into problems with the dependents
[quoted text clipped - 13 lines]
>
> Thanks for any help.

Reply to this Message