[Kenya]

Sorry, correction on the excel spreadsheet example. It did not keep the
correct format.
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

"Kenya" wrote:

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!!