[LT]

I want to send a letter to a group of producers. I have their addresses in
an excel spreadsheet. I can easily do this with a mail merge. I also want
to list all of the products they have registered. I have this information in
another spreadsheet. How can I accomplish this?

[Doug Robbins - Word MVP]

Word can only use a single flat file as a data source, so as a minimum, you
will have to combine the two files. You will then however end up with a
file in which the producers are each repeated for each product that they
produce and that then puts you in the trying to perform a "multiple items
per condition (=key field)" mailmerge situation which Word does not really
have the ability to do.

If you have Access, it would be easier to do it all in Access, using a query
that linked the producers from one table to their products in anothter table
and then use a report to generate the letters.

Alternatively, see the "Group Multiple items for a single condition" item on
fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"lt" wrote in message
...
I want to send a letter to a group of producers. I have their addresses in
an excel spreadsheet. I can easily do this with a mail merge. I also
want
to list all of the products they have registered. I have this information
in
another spreadsheet. How can I accomplish this?