How do I get one instance of every person

[zack]

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

 

[Doug Robbins - Word MVP]

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/cindymeister/mergfaq1.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