Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
kolwinsm kolwinsm is offline
external usenet poster
 
Posts: 1
Default Multiple Records / Rows from Excel to Word

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

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Multiple Records / Rows from Excel to Word

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


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;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

"kolwinsm" wrote in message
...
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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Merge - Excel Records to Word Table Columns NOT Rows eagleshout Mailmerge 1 May 14th 07 07:54 AM
MailMerge : 1 mail for multiple rows in excel. Santha Kumar Mailmerge 1 April 26th 07 01:44 PM
merge records are using too many decimal spaces when I use records from an Excel Database aspen Mailmerge 1 March 23rd 07 09:12 PM
Merging multiple rows in Excel to one word document. pammygamherst Mailmerge 1 December 25th 05 08:51 AM
How do I get multiple Excel rows merged into Word document when .. sebmailmerge Mailmerge 2 April 20th 05 03:47 PM


All times are GMT +1. The time now is 09:12 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"