Hi All

I have a problem with merging with access (or excel) that's doing my
head in, and I'm sure that it should be able to be done.

I have a list in Access of kids names and the school that they go to,
and I have the addresses of the schools in another table. Some schools
have 1 child's name, and some have up to 20. What I want to do is have
a letter for each school, and have the name(s) of the kids appear in
that letter, whether it is 1 name or 20 names, or something in
between.

There are around 300 kids names and around 100 or so schools.

If I do a report in access, i can group by school, but I can't seem to
convert this to the mail merge I want.

What I want is to have the merge field for the school name, and then
all the children's names for that school on the same page.

Any help with this would be appreciated.

Many Thanks

Moggle

Moggle:

Your best be is to:

1 create query with school, school addr, kid name
2, Write a report looking the way you want the letter to look.
3. You can group by school and force a pagebreak in the group footer.
You could just print it then, or export as rtf and bring into word if
you want something fancy.

Good Luck
Ira Solomon

Now I know "moggie" is brit for a cat, and "muggle" is a non-magical
human. What is a "moggle"? ( a non-magical cat?)



On 5 Aug 2003 07:32:39 -0700, aussiebird13 (AT) hotmail (DOT) com (Moggle) wrote:

you need to grab some code from www.mvps.org that collapses the 1-M
relationship in a query. then use that as the source for your mail
merge.

http://www.mvps.org/access/modules/mdl0008.htm