Share
ReportI need to make a Marketing List that includes Contacts from all companies that do not have any employees who are clients. Within a given Account, I have some Contacts that are clients and some that are not. I cannot simply use that property of the Contact, because if a Contact is not a client but in the same company as a Contact who is a client, then even the Contact who is not a client should not receive the marketing mail. Therefore, I need to query all Contacts whose Parent Account does not have any child Contacts that are clients. How do I build this query with out-of-the-box features?
*This post is locked for comments
All responses (
Answers (
291,280
