We are finally moving towards sending membership renewal notices by emails via WordFly. I set up a list in List Manager to pull everyone who is expiring at the end of the month, but then I went to set up a list of all those who are three months expired and it is pulling everyone with an expiration date three months ago, even if they have renewed and are current. I tried using a "NOT IN" criteria for Membership Status of Active, but that didn't kick anyone out. For others who have this set up, do you set up as an Extraction so you can suppress people and then have to schedule the Extraction to rerun every month? It seems like there should be a more automatic way of doing this that I'm just missing (please excuse the post-conference covid fog!). Thanks!
Anne RobichauxThe Historic New Orleans Collection
Hi Anne,
I think if you use Does Not Have instead of Not In, it will remove the current memberships.
An alternative would be to have a list of any current/pending memberships and then use that list as criteria to suppress renewed/renewing memberships.
HTH.
T.C.
Hi TC, Thank you! I think you have solved my problem. I'm going to spot check my lists to make sure, but it looks like this does exactly what I need and will allow me to just set this up to run without having to update each month.
Anne