Mail Merge Catalog from Excel

[Christine]

I have Microsoft Word 2000. Want to merge Excel database
to Word in Catalog form in a particular order:
<Company1>
<Category1>
<Product Division1> <MGR1> <Comments>
<Product Division1> <MGR2> <Comments> etc...
<Company2>
<Category1>
<Product Division2> <MGR10> <Comments>
<Product Division2> <MGR11> <Comments> etc...
(Multiple Companys/Categories/Prod Divisions/Mgrs you get
the idea...)
1. How do I get my Excel Data setup to work with Word for
this type of catalog merge?
2. How do I get my merge to get my data in the exact order
I want? (I found an example for just City, State,
Employee but am still not able to get my catalog right!)
Any suggestions are appreciated! Thank you.

 

[Cindy M -WordMVP-]

Hi Christine,

The example you found is probably the best you'll be able to
do: Word mail merge is NOT designed to do one-to-many
relationships. *Possibly*, it would work out to combine the
technique you've found with a DATABASE field for the Product
Division lines that look like they can be displayed in a
table format.

If you're not familiar with that technique, see here
http://www.knowhow.com/Guides/DatabaseInfo/DatabaseInfo.htm

If this still doesn't work for you, you probably need Access
to create the "catalog", or use VBA (no mail merge)

I have Microsoft Word 2000. Want to merge Excel database
to Word in Catalog form in a particular order:
<Company1>
<Category1>
<Product Division1> <MGR1> <Comments>
<Product Division1> <MGR2> <Comments> etc...
<Company2>
<Category1>
<Product Division2> <MGR10> <Comments>
<Product Division2> <MGR11> <Comments> etc...
(Multiple Companys/Categories/Prod Divisions/Mgrs you get
the idea...)
1. How do I get my Excel Data setup to work with Word for
this type of catalog merge?
2. How do I get my merge to get my data in the exact order
I want? (I found an example for just City, State,
Employee but am still not able to get my catalog right!)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail