Can I send emails to values from a multi select text field?
I want to be able to send emails to records entered or chosen from a multi select text field.
Forum Discussion
It sounds like Raj os asking how to send emails to whoever was selected in the multi select drop down.
They will first need to be parsed out into separate fields
so the formula for [email 1] would be
Part(ToText([my multi select field]),1,";")
The formula for [email 2] would be
Part(ToText([my multi select field]),2,";")
The in the Notification you just hand type those fields carefully listed vertically in the box
[email 1]
[email 2]
etc
[email 20]
They will first need to be parsed out into separate fields
so the formula for [email 1] would be
Part(ToText([my multi select field]),1,";")
The formula for [email 2] would be
Part(ToText([my multi select field]),2,";")
The in the Notification you just hand type those fields carefully listed vertically in the box
[email 1]
[email 2]
etc
[email 20]
When converted to a text value, the multi select field is semi colon delimited. The formula i suggested above
The formula for [email 2] would be
Part(ToText([my multi select field]),2,";")
uses a semi colon to separate out the separate email addresses. You seem to be trying to use a hyphen.
The other issue may have to do with the type of email Notification you are using. If these are email addresses, I believe that you will need to use a Notification of type "Open", and not "Recipient". So you will need to make a new Notification.
The formula for [email 2] would be
Part(ToText([my multi select field]),2,";")
uses a semi colon to separate out the separate email addresses. You seem to be trying to use a hyphen.
The other issue may have to do with the type of email Notification you are using. If these are email addresses, I believe that you will need to use a Notification of type "Open", and not "Recipient". So you will need to make a new Notification.