---
schema_version: "1"
id: 308687c0b1ca2c3c424677c9b33babcc539589e041004558c7980f996e0408ae
title: Create Deduplicated Mailing Lists from a Campaign
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sfdo/264-0-0/npsp_create_mailing_lists_from_campaigns.md
canonical_url: https://help.salesforce.com/s/articleView?id=sfdo.npsp_create_mailing_lists_from_campaigns.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 874c520bc4419de23745e6fe2ebcb2345a39b5cb5928db32451ea21400951b22
description: Although we live in the digital age, direct mail remains an important part of fundraising and outreach activities. But sending materials through the mail isn't exactly cheap and you really don't want to send the same piece of mail more than once to a given address. Donors want to see that your organization is effective and streamlined, and doesn't waste dollars on sending unnecessary mailings.
products:
  - Nonprofit
release: "264"
---
# Create Deduplicated Mailing Lists from a Campaign

Although we live in the digital age, direct mail remains an important part of fundraising and outreach activities. But sending materials through the mail isn't exactly cheap and you really don't want to send the same piece of mail more than once to a given address. Donors want to see that your organization is effective and streamlined, and doesn't waste dollars on sending unnecessary mailings.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/images/icon_note.png)

Note Watch the Nonprofit Salesforce How-To Series video: [Create Deduplicated Mailing Lists from a Campaign](https://www.youtube.com/watch?v=5B-xvi7hN5M).

NPSP can provide a deduplicated mailing list so that each address only appears once in the export file. Use the **Household Mailing List** action on your Campaigns to produce a deduplicated mailing list.

First, double check that the **Household Mailing List** action is available on Campaigns:

1. Find a Campaign record.
2. Click **Household Mailing List**.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/images/icon_note.png)
    
    Note If you don't see **Household Mailing List** in the action buttons, try clicking ![Drop-down arrow](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/nonprofit_success_pack/images/drop-down-arrow.png). If you still don't see it, your administrator may need to add it to the **Salesforce Mobile and Lightning Experience Actions** section of your Campaign layouts.
    
    ![Campaign record with Household Mailing List highlighted.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/nonprofit_success_pack/images/household-mailing-list-button.png)
3. NPSP runs a special report, called NPSP Campaign Household Mailing List V2, that displays only one row per Household Account.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/images/icon_note.png)
    
    Note The report is V2 because it's built for Lightning Experience.
4. Export the results to save a copy of the mailing list.

Here's an example of the report:

![Household Mailing List V2 report results.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/nonprofit_success_pack/images/household-mailing-list-report.png)

The Household Mailing List button appends the phrase "- Household Duplicate" to Campaign Member Status values of members identified as duplicates. For example, "Sent" becomes "Sent- Household Duplicate". As a result, you may need to adjust reports and automation tools that reference Status values.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/images/icon_note.png)

Note If you installed NPSP before version 3.157 (June 2019), you must unlock the Campaign ID filter in the Campaign Household Mailing List V2 report. This is necessary so the report URL can populate the Campaign ID dynamically. For instructions, read [Known Issues in Lightning Experience](https://help.salesforce.com/s/articleView?id=sfdo.npsp_troubleshoot.htm&release=264.0.0&type=5 "Understand how to resolve common configuration issues in NPSP and where to look for additional help.").