Not easily.
It is possible to create a query to GROUP BY the address fields, and then
write code to concatenate the names of the people at that address together
to use on the labels. There is an example of that kind of code in this link:
http://www.mvps.org/access/modules/mdl0004.htm
However, your case is considerably more complex - based on a number of text
fields for the address, and with the fun of trying to concatenate names that
may or may not have the same surname, esp. if the first name is optional,
and so on. After that, there may be valid cases where different people at
one address do require separate mailings.
Much better to do the job properly, by creating a table of households, which
has a foreign key field to the persons table. This correctly defines who is
in each household, and the address to use for the household, and the order
of the names on the label. You still have the job of concatenating the
names, but at least you get the correct people in the mailing.
