Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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

 
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 08:33 AM.

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

About Us

"It's about Microsoft Word"