Forums
Fundraising
Suppressing Deceased Constituents
Discussions
Resources
Mentions
Tags
Search the Community
More
Cancel
New
Replies
11 replies
Subscribers
413 subscribers
Views
380 views
Users
0 members are here
Related
Suppressing Deceased Constituents
Colleen Miller
$organization
over 9 years ago
Hello, we're having some troubles in suppressing deceased constituents and I'm hoping someone will be able to offer some assistance. We've been trying for quite some time now to figure out a way to suppress individuals who are deceased and households where BOTH members are deceased from lists and extractions. The way we've gone about it is to suppress any record where A1 is marked as deceased (as any household with a living member should have that member in the A1 position). Unfortunately, this suppresses any record in which one person is marked as deceased, even if the A1 constituent is not marked as such. We currently are not marking deceased individuals as inactive, but I know that's any option. Does anyone know of any pros or cons that go along with marking deceased constituents as inactive, especially within a household that has a living member? I assume it would not disrupt pulling the living member of that household, correct? And does anyone know why pulling on A1 Status = Deceased pulls in households with a living member? Thanks, Colleen
Parents
Terry Stevens
$organization
over 9 years ago
Colleen, I also struggled for months with this. No matter what I tried I was constantly finding my list manager query was not catching everyone. So what I found I had to do was create two different list manager queries. One for finding households with A1 deceased and one for finding (true) Individual accounts with A1 deceased. I then use both of these lists in my suppression for extractions and/or run my list manager lists against these to be sure I am not mailing to deceased. I have attached the queries to because they will not post correctly here.
A1 Deceased List Manager Queries.docx
Cancel
Vote Up
0
Vote Down
Sign in to reply
Cancel
Reply
Terry Stevens
$organization
over 9 years ago
Colleen, I also struggled for months with this. No matter what I tried I was constantly finding my list manager query was not catching everyone. So what I found I had to do was create two different list manager queries. One for finding households with A1 deceased and one for finding (true) Individual accounts with A1 deceased. I then use both of these lists in my suppression for extractions and/or run my list manager lists against these to be sure I am not mailing to deceased. I have attached the queries to because they will not post correctly here.
A1 Deceased List Manager Queries.docx
Cancel
Vote Up
0
Vote Down
Sign in to reply
Cancel
Children
Colleen Miller
$organization
over 9 years ago
in reply to
Terry Stevens
Thank you, I'll take a look at this!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Cancel