In my troubleshooting travels I often see areas of data that need to be corrected.
One of those areas is Householding. Frequently I find people who live at the same address who have different households. That means if you are using Household Salutation or Household Envelope Name in your merge letters, you are often missing someone. It also means you may be sending more than one letter to a single address.
I'd like to make an offer to you.
Here's what I will do. If you email me at mpanger@trailblz.com I will return to you a report (for free) in Excel 2007 format that will show you where you have more than one person at the same address, but they are not householded together.
I will need two things:
- Your database name or customer name and,
- Your email address.
The report will come back looking something like this:
In the sheet above, you can see that the house with AddressID of 162 has two different HouseholdID's. This is an indication that house should be reviewed to see if it should be re-householded. This will likely lead to a discussion regarding whether or not people with different last names should be householded together (see HomeAddressID 184 at the bottom of the sheet and notice the last names).