NEXTif Merge problem

[jobspm]

I have an Excel list of 400 names. Each name corlates with a dept. number and
manager name. My final result needs to be one sheet for each dept. number. I
created a "code" field and placed an x for the first record for each dept.

Currently, when I merge into Word, my first record is correct. When I place
the NEXTif and state NEXTif code less than 0, it places the exact infor from
the first record. And, if I have muplitple NEXTif statements, it places that
record that many times. The number of records can vary from one to 70, so I
need to have multiple NEXTif statements.

I hope this makes sense. I know in the long run what my customer would like,
I am just having a hard time getting there! Any help is appreciated!

 

[Peter Jamieson]

You may have spotted Graham Mayor's reply to a nearby question, which says:

-------------
How to use mail merge to create a list sorted by category -
http://support.microsoft.com/?kbid=294686

Fellow MVP 'macropod' has posted a tutorial on this, with working field
codes and a sample Excel data source which you can download from my website
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
-------------

Although it may not sound much like what you need, personally I would
head straight for the second of those two links.

Peter Jamieson

http://tips.pjmsn.me.uk