2 Replies Latest reply on Sep 4, 2013 5:26 AM by samjs

    Emailing Groups


      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






      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.

        • 1. Re: Emailing Groups

          No, export/import is overkill.


          If you're using FM12 you can just collect the relevant email addresses in a number of different ways:

          - if relationships and TOs already exist you can use GTRR to build the found set and then send the email (remember that the Send Mail script step has an option for "multiple emails: one per record in the found set"

          - if no relationships exist you can do a scripted find to produce the same found set and send the email

          - or do an executeSQL to collect the email addresses in a variable and loop through that to send out one email per collected email address





          • 2. Re: Emailing Groups

            Thanks for the great advice!