nextif function examples

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Small Potato - 13 Dec 2005 21:41 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 14 Dec 2005 05:19 GMT

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

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

> Would you please help me to nextif functions in Word? I am using Excel as
> the
[quoted text clipped - 4 lines]
> same
> form and go the next page of another employee.

Reply to this Message

Small Potato - 14 Dec 2005 22:24 GMT

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.

> 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
[quoted text clipped - 22 lines]
> > same
> > form and go the next page of another employee.

Reply to this Message