Hello,
I am trying to merge my interviewers for school interviews
with their interviewees. I have the db set up workably in
Access, and I have my one to many query working ok, but I
can't seem to get the one-to-many to work on my mail
merges. Instead, I get a different, one-to-one letter.
What I would like to do is have *one* letter for the
interviewer, e.g.,
****************************
Greetings Joe Interviewer,
You have the following candidates to interview:
Interviewee 1
Interviewee 2
Interviewee 3
All best,
Me
**************************
Is this type of mail merge possible? Thanks so much in
advance for your help...
Henry Biggs, Asst Dean
College of Arts & Sciences
Washington University
Saint Louis, MO 63130
314-727-8435
Cindy M -WordMVP- - 30 Dec 2003 07:25 GMT
Hi Henry,
Start with the discussion about one-to-many in the MailMerge
FAQ on my website (Special Merges section). There are links
to sample files. From the example you show, I'd say
concentrate on the DATABASE field approach.
> I am trying to merge my interviewers for school interviews
> with their interviewees. I have the db set up workably in
> Access, and I have my one to many query working ok, but I
> can't seem to get the one-to-many to work on my mail
> merges
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word
This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)
Badger - 05 Jan 2004 21:07 GMT
Hi Henry,
Have sent you some example files to show how this layout is achievable.
Check them out and see what you think.
Microsoft article Q211303 shows the workings.
Regards
Paul
> Hello,
>
[quoted text clipped - 33 lines]
> Saint Louis, MO 63130
> 314-727-8435
Henry Biggs - 06 Jan 2004 01:11 GMT
Hey,
Thanks so much for the files--I will check this out, but it
looks very promising.
I very much appreciate the help!
Henry
>-----Original Message-----
>Hi Henry,
[quoted text clipped - 45 lines]
>
>.