samjs

Emailing Groups

Discussion created by samjs on Sep 2, 2013
Latest reply on Sep 4, 2013 by samjs

I have created a database of music students and my goal is to email students, and or parents from groups such as the Band and Choir. I'm not quite sure how to tackle this

 

My Tables

Students

Parents

Groups

Grouplineitem

 

Ideally, I would like to choose multiple groups such has "Band" and "Choir", and give me the option to send to...

Students and/or

Parents the student is living with and/or

all parents

 

Then show them in a portal.

 

The relationship between the students who live with their parents are their address.

 

Should I find the students and parents from the various tables and export/import them into a separate table to send the email?

 

I'm open to all suggestions to accomplish this.

Outcomes