A
April K
Here is my question:
I have a main table that contains the complete contact
information for each stakeholder. This includes: name,
address, city, state, zip, phone, etc... What I need to
find is an easy way of designating when more than one
person is from the same household or organization.
For instance Jeff Jones and Tom Smith might both reside at
1234 Lincoln Way, No Where, US 55555. Currently, they
would both be entered into the database as individual
records. This generally works well for large companys &
organziations when recieving separate letters, invites,
notices, but for a property owner of a residence or small
business, several pieces of the same mail can be very
annoying.
What I would like to do is find a way to designate them as
being in the same household so that when we send out a
newsletter or invite - only one is sent to the address,
but is addressed to all of the household members. Any
thoughts....
Thanks in advance for your help.
~April
I have a main table that contains the complete contact
information for each stakeholder. This includes: name,
address, city, state, zip, phone, etc... What I need to
find is an easy way of designating when more than one
person is from the same household or organization.
For instance Jeff Jones and Tom Smith might both reside at
1234 Lincoln Way, No Where, US 55555. Currently, they
would both be entered into the database as individual
records. This generally works well for large companys &
organziations when recieving separate letters, invites,
notices, but for a property owner of a residence or small
business, several pieces of the same mail can be very
annoying.
What I would like to do is find a way to designate them as
being in the same household so that when we send out a
newsletter or invite - only one is sent to the address,
but is addressed to all of the household members. Any
thoughts....
Thanks in advance for your help.
~April