Pulling constituents with no email address

Hi all,

I am trying to clean up our email marketing lists and for that would like to pull a list of constituents that don't have an email in their records. I have been trying to use the "EAddress=null" in list manager but that doesn't work. i also tried leaving the value blank but it won't let me.

Thoughts on accomplishing this? Thanks!

Parents
  • Hi, Fernando:

     

    You could make a list of all constituents (“List A”), and a separate list of all constituents with an active, primary e-mail address (or however you define who has an e-mail address—“List B”).

     

    Make a third list and include the Other > List criterion twice. What you’ll add will look this this:

     

    List         Has                         (1 value selected) – [put List A here]

    List         Does Not Have  (1 value selected) – [put List B here]

     

    I use this type of list all the time. It may be low tech, but it works.

     

    Lucie

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera
    8390 NW 25th Street
    Miami, FL 33122

Reply
  • Hi, Fernando:

     

    You could make a list of all constituents (“List A”), and a separate list of all constituents with an active, primary e-mail address (or however you define who has an e-mail address—“List B”).

     

    Make a third list and include the Other > List criterion twice. What you’ll add will look this this:

     

    List         Has                         (1 value selected) – [put List A here]

    List         Does Not Have  (1 value selected) – [put List B here]

     

    I use this type of list all the time. It may be low tech, but it works.

     

    Lucie

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera
    8390 NW 25th Street
    Miami, FL 33122

Children
No Data