I need some help with this situation:

I have a database with children's names and their corresponding grandparents name. I need to create an invitation (I have already done this) and mail merge the children's names into the invitations to send to the corresponding grandparents. The problem that is arising is this: One grandparent may have 2 or 3 grandchildren that they are being invited to attend this special day with...I need the 2 or 3 grandchildren's names to show up on one invitation. So I think I may need a relationship between the grandparents names and all children's names that go with that grandparent before doing this.

I am quite confused and could use some help please!

Thanks!

Creating the invitations as an Access report will be easier for you to handle. In that case, you can sort and group by grandparent so that all the children will appear on the same invitation.

Doing this with a mail merge will require working with VBA to collect all the grandchildren into a single record. The way a mail merge works is 1-record = 1-document so 2 grandchildren can't automatically be combined for one document unless you do it before hand with a query and VBA.