Need help creating an advanced query

[TinaA]

Hi everyone,

I'm having trouble created an advanced query. I'm trying to create an advanced query that I can use as my email subscriber list. However, instead of including all my email subscribers and excluding all the AEM opt outs and bounces, the lookup seems to include everyone in the database. How do I correct this? I have updated my email campaign history. 

Thanks,

T

• Act! Premium Version 18.1
• Microsoft Office Version: 1705
• Shared Database
• Windows 7

[Roy_Laudenslager · Accepted solution]

Two main flaws, you need to group the opt outs and bounce backs with parenthesis and using all ORs means you will likely select all contact in the database.

[Roy_Laudenslager · Accepted solution]

Two main flaws, you need to group the opt outs and bounce backs with parenthesis and using all ORs means you will likely select all contact in the database.