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!!
Kenya - 13 Jun 2007 17:57 GMT
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
[quoted text clipped - 10 lines]
> John Robinson 2 20
> John Robinson 2 20
> 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
[quoted text clipped - 32 lines]
> 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!!
Peter Jamieson - 13 Jun 2007 18:15 GMT
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
>I currently keep an excel spreadsheet for all of my customers, and
>typically
[quoted text clipped - 38 lines]
> option
> does not look good to me. Any help is greatly appreciated! THANKS!!
Kenya - 13 Jun 2007 18:33 GMT
Not what I wanted to hear, but Thanks for the links. I am not able to access
Cindys but I printed the other one and I will try it out. Thanks!
> Hi Kenya,
>
[quoted text clipped - 56 lines]
> > option
> > does not look good to me. Any help is greatly appreciated! THANKS!!