How do I send mail to specific user when node is created?

Hi Drupal People:

Here’s the Scenario

I’m building a website for a gymnastics school. Their clients/users are parents, who sign their kids up for various gymnastics levels.

So, a parent registers an account and adds her kid(s) with corresponding program levels (i.e. Level 1, Level 2, Level 3, etc) directly into her user profile.

The school makes frequent program announcements such as practice times and locations. When they create the announcement node, they need it to be auto-mailed to parent who have kids in the relevant classes.

Example: “Practice has been rescheduled.” Audience: Level 1, Level 3, Level 10.

So only those parents who have kids in these respective levels should receive an email with the announcement.

Here Is My Current Setup

Students are added to parents’ profiles via the Field Collection module.

Registration form allows for addition of kids with respective levels. Multiple kids can be added, each with their own appropriate level. Levels are selected from the “Levels” Taxonomy.

My Approach

I’m attempting to build a user list using the VBO module and feed it into Rules to:
1. compare the announcement’s specified audience (taxonomy),
2. and only send to those users
3. that have a matching level (taxonomy term)
4. in their kid’s Field Collection

What do you think is the best way of configuring this requirement?

Thanks in advance!

Drupal version: 


Source: https://www.drupal.org/taxonomy/term/2/feed