Hi Kenya,
Unfortunately Word isn't designed to do this sort of thing.
If possible you would be better off creating a report in Access to do it.
Otherwise, I suggest you look at the "Group Multiple items for a single
condition" section on
Cindy Meister's website at
http://homepage.swissonline.ch/cindy...faq1.htm#DBPic
or
http://support.microsoft.com/default...b;en-us;211303
Peter Jamieson
"Kenya" wrote in message
news
I currently keep an excel spreadsheet for all of my customers, and
typically
do a simple mail merger for letters. My manager has asked me to create an
attachment letter with mult lines of information from a new excel
spreadsheet
I created and it keeps repeating the same information from line one only.
The headers for my excel spreadsheet are shown in example below and I
would
like to have them appear this way in word.
For instance, I need to send John Robinson a letter to explain to him his
old report information has changed an has been entered onto a new rept.
He
has 10 diff reports that he uses so I need to inform him of all of these.
I
tried to enter a table with three columns, his name, old rept, new rpt,
however the only rept displaying is the first one in the list. The excel
spread sheet is set up the same way, EXCEPT, the lines below his name and
above the next customers name are blank with the exception of the old rept
and new rept information, see below.
EXCEL Spreadsheet
Cust Name Old Rpt # New Rpt #
John Robinson 2 20
3 38
13 69
Sally Smith 5 15
6 60
8 87
WORD
Cust Name Old Rpt # New Rpt #
«CustName» «Old_R» «New_R»
«CustName» «Old_R» «New_R»
«CustName» «Old_R» «New_R»
WORD after merge
Cust Name Old Rpt # New Rpt #
John Robinson 2 20
John Robinson 2 20
John Robinson 2 20
If I cannot find an answer, I will have to do this manually, and that
option
does not look good to me. Any help is greatly appreciated! THANKS!!