How do I search in the contacts search / Advanced search that I get only contacts with complete postal address?

I have many contacts in civicrm. Some have only city and country names, which is not very useful in terms of sending postal mailings. So how do I get the results in which I get the contacts with complete address?

1 Answer 1


You can use the search builder to search for empty fields, e.g. Steet-Address or ZIP Code. From the result, you could create a (smart) group and then exclude contacts in that group from the mailing.

  • 2
    I think 'serach generator' means Search Builder which you find under the Search link in the Admin Menu
    – petednz - fuzion
    Commented Jul 22, 2017 at 1:05
  • Suppose I have few groups. And in each group, I need contacts with complete address separately, how do I get that? Commented Jul 22, 2017 at 7:33
  • 2
    Thanks Pete, I changed it to Search Builder. @ParthibarajRajasekar: You would use the Include-Exclude Search (yoururl.org/civicrm/contact/search/custom?csid=4&reset=1), include your main group(s) and exclude your "no postal address group". The result would then be all contacts taht match your main group's criteria minus those without a postal address. If you make the groups smart, you do not have to build the search again every time you use it.
    – Fabian
    Commented Jul 24, 2017 at 5:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.