While I would do the whole thing in Access, fellow MVP Macropod has put
together a"Word 97-2007 Catalogue/Directory Mailmerge Tutorial" that should
show you how to do it with mailmerge. You can download it from:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.
--
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, originally posted via msnews.microsoft.com
"HRattner" wrote in message
...
I need some help. I have an access query that I run that pulls a person's
information and repeats that information in rows for each of their
dependants.
I need to communicate with these persons via email and fax. I would like
to
use Word's merge capabilities to do so, but when I build the information
into
word, I get a new page for each of the persons dependants. This will
cause
them to get several faxes and emails. I want to send them one email/fax
that
lists the persons information and then lists their depedant's information.
I'd also like to sort this by their company. So I want to categorize the
email by company name, person, and person's dependants. How do I go about
doing this, and it is even possible?