Merging data from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Akira - 24 Aug 2004 00:47 GMT

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

Reply to this Message

Cindy M -WordMVP- - 24 Aug 2004 16:41 GMT

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.
[quoted text clipped - 7 lines]
> 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 :-)

Reply to this Message