Populating email address fields with multiple... . Using FileMaker Pro . Forum . FileMaker Forums | filemakerpro | Scoop.it

Title:  Populating email address fields with multiple addresses

Post:  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.

3 tables:

  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:.

 

Sending with email client, SMTP server, webmail, or plugin??

 

#Perform a find to find all the records that contain an email address to which you plan to send the email
Go To Record [First]
Loop
#In the next step change ; to , if you need to use that delimitter for your email software
Set Variable [$EmailList; Value: $EmailList & "; " & YourTable::YourEmailField]
Go To Record [next; exit after last]
End Loop
Set Field [YourTable::YourGlobalSendField; Right($EmailList; Length($EmailList) - 2 /* strip off the leading "; " */]
#Now you can use YourTable::YourGlobalSendField as your specified field to send out your email

 

"Conventional Wisdom"

However, to send one email using the recipients represented by all records in the found set, you would have to have your script loop through all records and store the list of emails to a local variable or to a global field, and then send the email using the 'one email' option and using that variable or global as your recipient.

 

http://www.filemaker.com/11help/html/import_export.16.7.html

Home > Sharing data > Saving, importing, and exporting data > Sending email messages based on record data > Sending one email message

 

http://www.filemaker.com/11help/html/import_export.16.9.html#1038462

Home > Sharing data > Saving, importing, and exporting data > Sending email messages based on record data >
Entering or editing SMTP options

 

http://dwaynewright.squarespace.com/filemaker-thoughts/2012/2/17/the-filemaker-send-mail-script-step.html

The FileMaker Send Mail Script Step February 17, 2012

 

http://buzz.beezwax.net/2012/11/02/sending-html-email-from-filemaker

Sending HTML Email from FileMaker Posted by donovan 11/02/2012 Demo databases available

 

http://filemaker-plugins.com/compare/email-plugins/
2010 Filemaker Email Plugins Compared

 

http://www.campaignmonitor.com/resources/will-it-work/email-clients/

Email Client Popularity

• 35.6% iOS Devices

• 20.14% Outlook

• 13.57% Hotmail
• 11% Apple Mail

• 9.85% Yahoo! Mail

• 8.43% Gmail
• 4.74% Android

• 2.34% Windows Live Desktop

• 1.03% Thunderbird
• 0.79% AOL Mail

 


Via David Anders