mail merge with one to many issue

  • Thread starter Thread starter DDWalker
  • Start date Start date
D

DDWalker

I'm a volunteer using Access db with sponsors and students. Some sponsor many
students, some only one. Using Word, I need to have one letter per sponsor
(see below)and print all of the students names that they sponsor plus
individual info about the students like 'year' 'date' 'grade', etc rather
than one letter for each student. I did this kind of work in my regular job
years ago but don't know how to do it using Access.

(sponsor)John Jones
(student)Jim Adams "2008" "passed grade 1" "98"
Steve Post "2008" "failed grade 7" "67"
Arial West "2008" "passed grade 3" "89"
 
Two ways, make a report that looks like a letter and group-by sponsor or use
word and do a merge, again using sponsor as the control to group-by <next
record if>and access as the data source. As you know word the second option
might be easier for you.
 
Back
Top