AnsweredAssumed Answered

Help creating a FMP 10 Script that only includes fields with email addresses

Question asked by AAgraphics on May 10, 2010
Latest reply on May 12, 2010 by AAgraphics

Title

Help creating a FMP 10 Script that only includes fields with email addresses

Post

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?

Outcomes