Excel and Word - mult lines on info on excel for one customer [WiredBox.Net

> Cust Name Old Rpt # New Rpt #
> John Robinson 2 20
> 3 38

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

> 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/cindymeister/mergfaq1.htm#DBPic
>
> or
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;211303
>
> Peter Jamieson
>
> "Kenya" <Kenya[ at ]discussions.microsoft.com> wrote in message
> news:D1536E1E-F65B-4E7D-964D-C88102723703[ at ]microsoft.com...
> >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!!
> >
> >
> >
> >
> >
> >
> >
>
>