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.

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/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Articles

http://support.microsoft.com/default...b;en-us;302665


http://support.microsoft.com/default...b;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" Small wrote in message
...
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.

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.


"Doug Robbins - Word MVP" wrote:

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/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Articles

http://support.microsoft.com/default...b;en-us;302665


http://support.microsoft.com/default...b;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" Small wrote in message
...
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.