I have a content type (school) with an unlimited email field (field_email). Now on creation of another node (page), I would like to send to all emails stored in the "field_email" of all school nodes an email.
I started by created a rule with the "rules" module but i cannot figure out how to pull the data from a separated node (school).
Could someone point me in the right direction?