Merge data form several records

[Meenu Hodiwalla]

Hi,

This is an earlier query of mine, in response to which
Peter Jamieson had requested more details. I think that
thread got ignored therafter due to the numerous messages
being posted ! So here is my problem again :

I need to merge data from more than one record in the
database, into my word documents. The only way I have been
able to do this is to create 3 separate word documents,
each taking data from a single database record. Then, in
the main document, I cut and paste the stuff from the 3
documents (I have a macro to do the cutting and pasting).

The database contains information pertaining to various
countries. Each country could have several contact
persons, so the database has one record per contact. The
databse has 2 fields (amongst others) - CountryName &
Contact. So for example, if Switzerland has 3 contacts,
There are 3 records in the database, each has CountryName
= Switzerland, and Contact for each is different
(Switzerland1, Switzerland2, Switzerland3).
I then have one word document for each country, on which I
want to display the data for all the contacts in that
country. Since each document pertains to a specific
country, I know which records I need to pick up (in this
case, Switzerland1, 2 & 3).
I guess the ideal solution would be to have all this in
Access, but the users are used to word.

Is there a better way of doing this in word ?

Thanks for helping.

 

[Peter Jamieson]

I did post a reply but I guess it never reached you:

---------------------------------------------
OK, the usual approaches to this kind of problem are the ones described by
Cindy Meister on her website at

http://homepage.swissonline.ch/cindymeister/

Look for Mail Merge FAQ, special merges, multiple items per condition.

However, if you want good control over the layout of the contact info., you
will probably not find the DATABASE field approach very useful.