1. 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.
  2. 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.  
  3. In a Mail function (such as Quick Letters), exclude constituents with the description of No.  
  4. 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. 

OR

  1. 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. 
  2. 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>) 
  3. 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 
  4. Merge the queries with Query A as primary, Query B as secondary, and SUB as the operator 
  5. Use this query in the export 

OR

  1. 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. 
  2. Export the addresses to Excel using Mail or a constituent export
  3. 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. 

OR

  1. Create an export in Excel or CSV (comma separated values) format containing all the constituents who should receive the mailing 
  2. Open the file in Excel. 
  3. Sort the spreadsheet by the Address Lines or the Address Line 1 column
  4. Manually delete the duplicate addresses OR hide the duplicate rows.