What option are you using to send the email? Are you sending one email at a time or using the "Multiple Emails" one for each record in found set option?
Either way, there are a number of ways that you can use to omit the records where the email address is empty. One simple way, is after you pull up the crew records as your found set, enter find mode, put an asterisk in the email address and choose Constrain Found Set and that will omit the records that do not have an email address.
The way I have the script set up is - omit all records except the one being viewed so one record is shown. Then there are 7 fields - one for the project manager and 6 for the crew. So it would be one email for the one record found. The problem being if any of the fields referenced for the Send Mail script is empty, the script fails.
These are the field names:
To: Work Orders::PMEmail
CC: Work Orders::CrewMemberEmail1 & P & Work Orders::CrewMemberEmail2 & P & Work Orders::CrewMemberEmail3 & P & Work Orders::CrewMemberEmail4 & P & Work Orders::CrewMemberEmail5 & P & Work Orders::CrewMemberEmail6
The "P" being a paragraph maker used in the calculation window
Does something have to be present in the email fields in order for the script to successfully generate an email? I should mention we are using Entourage 2008 and Outlook 2011 for Mac.
Check to make sure you have the correct list delimitter for your emails. For most such lists, you need either a semi colon or a comma to separate the emails:
Substitute ( List ( Work Orders::CrewMemberEmail1 ; Work Orders::CrewMemberEmail2 ; Work Orders::CrewMemberEmail3 ; Work Orders::CrewMemberEmail4 ; Work Orders::CrewMemberEmail5 ; Work Orders::CrewMemberEmail6 ) ; ¶ ; "; " )
List drops out the blanks, but produces a list of values separated by returns just like your original expression. The substitute function then replaces the returns with semi-colons to use as the delmitter. In your case, you may need to use a comma instead.
AWESOME, AWSOME, AWESOME! That totally worked. OMG! If you were standing here I would totally hug you!