nextif function examples

[Small Potato]

Would you please help me to nextif functions in Word? I am using Excel as the
data sources and merge to a Word template. My idea is to put the data record
in the same merge document until the change of a field. E.g. To put all
employee personal data, (name, address, birthdate, phone, etc.) on the same
form and go the next page of another employee.

 

[Doug Robbins - Word MVP]

If you have all of that data in separate fields (columns) in the Excel data
sheet for each employee then a formletter type mailmerge will produce what
you want.

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

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 Articles

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


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


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

 

[Small Potato]

Hi, Doug

Thank you for your help. I do appreciate that.

I did try to duplicate the steps provided by the 'Group Multiple items for a
single condition' document in Cindy Meister's websit.

It seems working except the "P" & "t" codes. "P" is expected to represents a
parapraph mark that pushes the next project to a new line, and "t" represents
a tab character that aligns the next project under the previous project.

The most challenging part is how to set up for a new page automatically as
the group change.