- From Analysis, Click Information Library, Add and ad-hoc query and choose the source view of Constituents
- On the left expand Members, select Membership. From the middle drag Membership level to Include records where and set equal to the Membership Level.
- On the left select Relationships. From the middle drag Reciprocal relationship type to Include records where and set equal to the relationship type
- On the left expand Relationships, Expand Related Constituent, Select Email Address. From the middle drag Primary Email address to Include records where and set equal to Yes. Add a left parenthesis.
- From the middle drag Email address to Include records where and set is blank. Make this an OR statement and Add a right parenthesis.
- From the middle drag Email address to Results fields to display
- On the left Expand Relationships, Expand Related Constituent. From the middle drag name to Include records where
Blackbaud Community
Connect and collaborate with fellow Blackbaud users.