Showing results for 
Search instead for 
Do you mean 

Advanced query

Copper Contributor
Posts: 38
Country: United States

Advanced query

I would like to do a query to find contacts with an email address within a group or ID status.  Not sure how to do it if the email field is blank.





Copper Contributor
Posts: 63
Country: USA

Re: Advanced query

First, perform the lookup by ID/Status or Group. Then click Lookup | E-mail. Click on the drop-down in the middle that says "Starts With" and change it to "Contains Data". In the drop-down labeled For the current lookup: where it says "Replace Lookup", change that to "Narrow Lookup". Then click OK and you'll have a look up of your ID/Status or Group contacts that have *something* in the e-mail field. 


Hope that helps -  

Stacy Roach
Swiftpage Gold Drip Marketing Certified Consultant
San Francisco Bay Area
Email Stacy