Populating email address fields with multiple addresses
I am trying to figure out how I can populate the To:, Cc:, or Bcc: fields with multiple emails based on a criteria. The basic design is like this.
Discipline - Basic table with a discipline (Nuclear Engineering, Mechanical Engineering, Materials Science etc.) each with a unique id.
Contacts - Obviously contains the email address and other information for each person along with a unique id. In this table you select a discipline for each person from a pop-up menu using a value list populated by the Discipline table.
Email - This table contains your basic email information. I already have everything set up so that if I manually enter addresses and messages I can click a button that says Send Mail and FileMaker exports the information to the appropriate fields in my email client. This works perfectly.
What I would like to do is create a button for the To:, Cc:, and Bcc: fields that will automatically populate these fields with email addresses related to the selected discipline (this is also populated by the Discipline table). In theory, if you have Materials Science selected as below and you press the Bcc: button, I want FileMaker to automatically insert all of the email addresses associated to Materials Science in the Bcc:. The same thing would happen with To: and Cc:.
Thanks in advance!
FMP 12 Advanced