Using NEXTIF to compare to next record

[swoosh641]

I was trying to create a mail merge document to go to a bunch of supervisors.
The excel document I am mergin from has a column of employee names and then
a column with corresponding supervisors for each employee (and sundry other
columns of employee information). The data in the excel file is sorted by
supervisor name, so all records of the same supervisor should be next to
eachother. I would like to create a merge document that essentially creates a
word document for each supervisor that lists all employees and each employees
other field information that they supervise (with a brief informative text on
top of the list).

The only way I can see that this would be possible is if I was using the
NEXTIF command and comparing the "supervisor" field from the next record to
the "supervisor" field of the current record and having it break to a new
merge document when they were not equal.

I wasn't sure if their was a function or syntax to make this work. Does
anyone know how to make this work?

 

[Doug Robbins - Word MVP]

To see how to do this, take a look at:
http://cornell.veplan.net/article.aspx?&a=3815

or fellow MVP, macropod's tutorial on Catalogue/Directory Mailmerges at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107


--
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