Send email according to query results

Hi experts,

I would like to know if it's possible to send an email according to query results.

Let me explain my scenario:

I have a query with a user list, and a calculated key figure, Exemple :

User -- KF:
KHA -- 0
ABE -- 1

TRT -- 1
USR -- 0

The user characteristic is a MasterData with an attribute called "email" containing the email of the user.
I would like to know if it is possible to planify an automatic sent ( for example every friday at 10am) for each user where the calculated key figure equals 1.
If possible, how should I proceed ?
Thanks