Help creating a FMP 10 Script that only includes fields with email addresses
Using FMP 10 on Mac and PC
Okay, so I had a script set up that was sending an email to one recipient and copying several recipients. The CC'd recipients were from four other fields. Sometimes all four fields were filled, other times only one or two fields were filled.
On the script, the CC field looks like this:
table::VendorEmailAddress02 & ";" & table::VendorEmailAddress03 & ";" & table::VendorEmailAddress04 & ";" & table::VendorEmailAddress05
The problem is that if some of the fields have no data, the email will not send from a PC. So how can I write a script that will only output email addresses if the field is filled? Any ideas?