Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I get one instance of every person
I would really appreciate some help to resolve this issue, as has got
me completely baffled. I have an Access database containing approx 3000 students. StudentTable contains all contact data. It is connected via a junction table to SubjectArea which contains details of which subject areas they have expressed an interest in. This could be one or many subject areas. I now want to be able to mail-merge all 3000 students a single page letter, which at the bottom of each letter, shows a list of which subject areas they have expressed an interest in, so that the relevant course leaflets can be included in with the covering letter. Currently when I try to mail-merge through Word, it producing a letter for every instance of a student requesting a sbject area. So for example, there are 6 letters being produced for Mr Smith because he asked about 6 courses. When in fact I want one letter for Mr Smith, showing the six courses he has expressed and interest in at the bottom. I there anyway to do this? Any pointers would be really helpful. Thanks Zack |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I get one instance of every person
The simplest way is to create your letter as a Report in Access.
Word does not really have the ability to perform a "multiple items per condition (=key field)" mailmerge. See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic -- 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 "zack" wrote in message oups.com... I would really appreciate some help to resolve this issue, as has got me completely baffled. I have an Access database containing approx 3000 students. StudentTable contains all contact data. It is connected via a junction table to SubjectArea which contains details of which subject areas they have expressed an interest in. This could be one or many subject areas. I now want to be able to mail-merge all 3000 students a single page letter, which at the bottom of each letter, shows a list of which subject areas they have expressed an interest in, so that the relevant course leaflets can be included in with the covering letter. Currently when I try to mail-merge through Word, it producing a letter for every instance of a student requesting a sbject area. So for example, there are 6 letters being produced for Mr Smith because he asked about 6 courses. When in fact I want one letter for Mr Smith, showing the six courses he has expressed and interest in at the bottom. I there anyway to do this? Any pointers would be really helpful. Thanks Zack |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening New Instance | Microsoft Word Help | |||
How to get a new page for each person | Mailmerge | |||
Each doc opens a new instance of Word | Microsoft Word Help | |||
Smart Tags - Person Name | Microsoft Word Help | |||
Mail merge opens 2nd instance of Access | Mailmerge |