Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
pammygamherst
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M -WordMVP-
 
Posts: n/a
Default 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

Posting Rules

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Does Word have a QuickCorrect/Quick Word option like WordPerfect? CW New Users 2 December 20th 05 06:54 PM
Envelope Address GR New Users 5 April 24th 05 09:48 PM
How do I get multiple Excel rows merged into Word document when .. sebmailmerge Mailmerge 2 April 20th 05 03:47 PM
Macros - Keyboard Commands Janet Microsoft Word Help 6 April 11th 05 05:28 AM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 13th 05 12:30 AM


All times are GMT +1. The time now is 06:09 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"