How do I page with a change in data value?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 29 Jun 2006 17:04 GMT

I'm using Word 2003. I've done a mail merge with an excel spreadsheet. The
worksheet has fields for a name, date, and customer. Several rows can be
associated with one name. I've gotten my word document to show the different
dates and customers on one page with the Nextif field; however, I want it to
page with a change in name. I'm assuming a have to write a macro--because I
don't see a mailmerge field I can use.

Reply to this Message

Doug Robbins - Word MVP - 29 Jun 2006 18:20 GMT

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

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 Article

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

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

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

> I'm using Word 2003. I've done a mail merge with an excel spreadsheet.
> The
[quoted text clipped - 6 lines]
> I
> don't see a mailmerge field I can use.

Reply to this Message

Tim - 29 Jul 2006 14:56 GMT

This helped somewhat. Unfortunately, I'm trying to e-mail Merge from Word on
a field called "Clinician_Name". If a clinician has more than one patient,
i.e. 5, its sending 5 e-mails to that person (I used the Microsoft link/the
other two were confusing).

> Sounds like you are probably trying to perform a "multiple items per
> condition (=key field)" mailmerge which Word does not really have the
[quoted text clipped - 21 lines]
> > I
> > don't see a mailmerge field I can use.

Reply to this Message

Rate this thread: