Merging data from Access

[Akira]

HI

Do not know how to explain this so please bear with me

1. I have a Word form that I want to email using Mail
Merge.
2. I have MS Access Table that has a list of errors
for each dept secretary

3. I want the mail merge to merge this data from access
to word. BUT I want one form sent to each secretary
with the list of errors that belong to that secretary

The table contains an Email address for each
record

 

[Cindy M -WordMVP-]

Hi Akira,

What you want is what I term a "one-to-many" merge. This is
not something Word knows how to do, on its own. It is
possible, but involves a bit of work. You'll find a short
discussion, with links to sample files, on my website; look
in the "Special merges" section of the Mail Merge FAQ. From
what you describe, I'd say you could use the Database field
approach, which should be the easiest to set up.

1. I have a Word form that I want to email using Mail
Merge.
2. I have MS Access Table that has a list of errors
for each dept secretary

3. I want the mail merge to merge this data from access
to word. BUT I want one form sent to each secretary
with the list of errors that belong to that secretary

The table contains an Email address for each
record

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

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