We have a case where in a database used for lookups in Forms, a field may contain multiple email addresses separated by semi-colons. Forms sees the entire field as 1 email address and fails when trying to send an email out. It would be nice if Forms could interpret these values correctly so an email could be sent out to each address.
Question
Question
Feature Request: Allow Use of Multiple Email Addresses in Lookup
Replies
Just a suggestion here Blake, create a SP or a view and separate out the emails to each line in the view itself on database, but if that's not an option you can use a workflow to send emails and workflow can clean up the emails fields for you.
But i hear you it should be able to send emails to multiple email address based on single field as long as it's formatted correctly (aka using ; and not , or other character). I am going to attempt that right now myself and see what errors it gives, does it only send to one address or to none at all ?
Sumeet, it doesn't send to an email at all because it looks at the value of the entire field, which isn't a valid email address when looked at that way.
I have looked at creating a view, but I'm trying to go with the idea of it would be nice if it worked out of the box that way without special configuration.