Multiple Records / Rows from Excel to Word

[kolwinsm]

I have a letter that we are pulling the data source from Excel - lists
customer name, product name, - one customer could have multiple products.
How do we get one letter for each customer with multiple rows if necessary.
Also - 3 sections are in letter - one for if product # is changing, one if
product # remains the same, one if product prefix is changing. Some customers
will only be affected by one change. Is there a way to merge the data into
the correct positions? example below (should be in table format).
PREFIX
The following will be converting to a "46025" prefix. The remainder of the
product number will not change. There is a change to the description.

Material Description Future Material Future Description
91038-15300-00 120/1.5 Oz, Square Patty, Express
Egg,3" 46025-15300-00 120/1.5 Oz 3" Sq Pty, Tbl Rdy, PHE

SAME
The following will have no change in the product number, but the description
will change. Since no changes to your orders will be needed during this
transition, you will not receive notification as the changes occur. If you
need notification, please contact your Broker or Michael Foods Account
Representative.

Material Description Future Material Future Description
46025-74030-00 1/18 Lb, IQF Biscuit Scrambled Eggs, CN Same 1/18 Lb Biscuit
Scram Eggs, Tbly Rdy, PHE
46025-85423-00 1/23 Lb, IQF Scrm Egg Curds, CN, Spc Cut Same 1/23 Lb Scram
Egg Curd CN, Tbl Rdy, PHE

CHANGE
The following will become a new product number with a new description. The
replacement product is listed.

Material Description Future Material Future Description
14616-52025-00 153/1.5 OZ, IQF PATTY, QS EXP 46025-89238-00 153/1.5 Oz 3.5"
Rd Pty, Tbl Rdy, PHE

 

[Doug Robbins - Word MVP]

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

or at:

http://cornell.veplan.net/article.aspx?&a=3815

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