Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging multiple rows in Excel to one word document.
I have an Excel document that is tracking actions for a person. Each person
has multiple rows (each row holds one unique action id). When I merge in Word the number of documents created for each person is equal to the number of rows that person has in the Excel file. For example, one person has 7 rows and then when merged 7 documents are created and the documents contain actions that are not associated with that person. The way I got around this before was creating a table in Access, not Excel, and giving each action id a unique field identifier (creating a one-liner for each person) then I used that table for my word document merge template and the data merged successfully. Is there a way to do this in Excel or another way? I am using a relational database and an internal reporting tool within that database to extract the data initially, then using a database query in Excel to retrieve into Excel. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging multiple rows in Excel to one word document.
Hi ?B?cGFtbXlnYW1oZXJzdA==?=,
On my website you'll find a short discussion of the "one-to-many" problem, with three possible approaches, and links to sample files. Given your description, I'd say try the database field approach, first. I have an Excel document that is tracking actions for a person. Each person has multiple rows (each row holds one unique action id). When I merge in Word the number of documents created for each person is equal to the number of rows that person has in the Excel file. For example, one person has 7 rows and then when merged 7 documents are created and the documents contain actions that are not associated with that person. The way I got around this before was creating a table in Access, not Excel, and giving each action id a unique field identifier (creating a one-liner for each person) then I used that table for my word document merge template and the data merged successfully. Is there a way to do this in Excel or another way? I am using a relational database and an internal reporting tool within that database to extract the data initially, then using a database query in Excel to retrieve into Excel. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Word have a QuickCorrect/Quick Word option like WordPerfect? | New Users | |||
Envelope Address | New Users | |||
How do I get multiple Excel rows merged into Word document when .. | Mailmerge | |||
Macros - Keyboard Commands | Microsoft Word Help | |||
How do I create & merge specific data base & master documents? | New Users |