Questions

Access 2007 Mailing Label

+
0 Votes
Locked

Access 2007 Mailing Label

michael.ludlow
I wonder if anyone has come up against this problem needing a solution.
My database contains tables entitled Units, UnitOccupiers and Occupiers. These three are connected in an M:N Relationship.
The table of Units identifies a particular condo.
Occupiers has identification and mailing information. Ownership of units may be single or joint. A unit may be owned by a husband alone or it may be registered in the names of a husband and wife. There are other relationships which could result in a joint ownership. One individual may own one or more units of accommodation.
The UnitOccupier table is the joining table in this M:N relationship and may have the following records containing the foreign keys of the other two tables plus a category field to establish the different occupying situations for the same individual. Owner-Occupied, Non-Resident Owner and Lessees of varying nature.
1. 123 A St. #401, Naples, FL 33954 John Hancock, Owner Occupier, 123 A St. #401, Naples, FL 33954
2. 123 A St. #401, Naples, FL 33954 Mary Hancock, Owner Occupier, 123 A St. #401, Naples, FL 33954
3. 124 A St. #501, Naples, FL 33954 Tom Chance, Lessee, 124 A St. #501, Naples, FL 33954
4. 124 A St. #501, Naples, FL 33954 **** Plake, Owner Non-Res, 6500 Anthem Drive, Naples, FL 33900
5. 124 A St. #501, Naples, FL 33954 Harry Lyme, Owner Non-Res, 6500 Anthem Drive, Naples, FL 33900
Each month there is a mailing to the owner(s). In the above example an individual mailing would go to records 1, 2, 4 & 5 [owners only]. It seems pointless to send two reports to the same mailing address. What we would like to see is one mailing for Records 1 and 2 and another for 4 and 5.:
John & Mary Hancock,
123 A St. #401,
Naples, FL 33954
**** Plake and Harry Lyme,
6500 Anthem Drive,
Naples, FL 33900
I believe the answer may lie in VBA using an array but I don?t have the experience to investigate that properly.
I would appreciate any ideas. mjl