linking parameter query with Word Mail Merge

R

RJE

I am creating a database for another user who is
unfamiliar with queries, including the MS query function
in Word Mail Merge. I am trying to automate my design as
much as possible. I have created a database which uses
parameter queries to pull specific names for labels (which
only requires the user to enter one ID #) within access.
However, I am struggling to link these with a Word Mail
Merge document (the form letter being mailed). What I
would like is that the user can click on "Merge" then be
prompted for the ID # and the letters merge. However,
whenever I try to set it up that way, Word asks for the ID
# for that parameter at the time of set up.

Is there any way to do what I am wanting to do? If not,
does anyone have an alternate suggestion to accomplish the
goal of automating the form letters?

Thanks,
RJE
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top