Creating a Merge List/Directory

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richie - 27 Apr 2004 15:54 GMT

I have data in several rows of an Excel spreadsheet that I
need to go onto one document. For example, several rows
have the same city. I need all of the rows with the same
city to merge onto one document and then all of the rows
of the next city merge onto another document, etc.

Here is an example of my data:
City Name
--------------
Dallas Richie
Dallas Justin
Dallas Andrew
Chicago Julie
Chicago Bill

How can I get all of those in Dallas to be listed on one
merged Word document and all of those listed in Chicago on
another document? Thanks for the help!

Reply to this Message

Graham Mayor - 27 Apr 2004 16:14 GMT

The short answer is that you can't. You could, try the techniques suggested
at http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#ComplexMerg
then split the resulting document
or you could create separate merges for each city

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I have data in several rows of an Excel spreadsheet that I
> need to go onto one document. For example, several rows
[quoted text clipped - 14 lines]
> merged Word document and all of those listed in Chicago on
> another document? Thanks for the help!

Reply to this Message