- Create a Yes/No constituent attribute to denote that the constituent has the same address as another constituent. Call it Main Address or something similar.
- Add this attribute to all the records that have the same address. On the constituent's record that should receive the mailings, enter a description of Yes. On the other constituents' records that should not receive the mailings, enter No.
- In a Mail function (such as Quick Letters), exclude constituents with the description of No.
- Run the mailing.
Note: If only two constituents have the same address and they are linked on the Spouse button, use head of household processing in version 7 or mark the Exclude duplicate spouse checkbox in version 6.
- Create a Yes/No address attribute to denote that the constituent has the same address as another constituent. Call it Main Address or something similar.
- Create a constituent query (Query A) of those you want to mail to. Ensure this query includes the constituent with the Main Address attribute description of Yes. (Note: It can also include the constituents with the Main Address attribute description of No>)
- Create another constituent query (Query B) for those with the Main Address attribute of No. The filter is:
Attributes, Specific Attributes, Main Address, Attribute Description equals No
- Merge the queries with Query A as primary, Query B as secondary, and SUB as the operator
- Use this query in the export
- Add a table entry to the Address Types table that indicates the address is a duplicate. For example, if a student lives with her parent, add the address type Parent Address to the student's address.
- Export the addresses to Excel using Mail or a constituent export.
- In the Excel file, globally delete all addresses with the address type that indicates it is a duplicate address (e.g., Parent Address). For assistance with this process, consult your IT professional.
- Create an export in Excel or CSV (comma separated values) format containing all the constituents who should receive the mailing
- Open the file in Excel.
- Sort the spreadsheet by the Address Lines or the Address Line 1 column.
- Manually delete the duplicate addresses OR hide the duplicate rows.