mail merge addressee tangle

[soojosie]

Hi,
I have an access table with 3 different types of addressees.
1. Couples with same LastName
2. Couples with different LastNames
3. Individuals.

I'm trying to use mail merge.
But it can't differentiate between the 3 different varieties
what I would like is:
1. Anna & Jay WHITE - This works O.K.
2. Marie SMITH & Katie BROWN - Here I'm get Marie & Katie SMITH
3. Jason BLACK - weird but here I get “The BLACK Family”??!!
this is when using the “Insert Address block” function in mail merge

What is the correct way to ensure all members are addressed correctly?

Do I need to run separate queries? Is there a better way?

thanks

 

[Joe4]

It is really hard to say without seeing your table structure and the calculations in your query.

You could create a query with the logic/calculations to handle each instance appropriately
-or-
you could create three separate queries to handle each instance accordingly, and sew them back together with a UNION query.