I am trying to loop through a list and email people. The email addresses are on column called 'Emails' (defined as single line of text)
The emails are written in the following format on each field
When I select the above field at my 'To' field, the workflow is not sending emails and gives me following error
'Exception: Unable to send email to group, Please ensure that the visibility of the group under Group Settings is set to everyone'
I checked to see how this field is queried and this is the result.
How can I correct this problem? Any help is appreciated!
Solved! Go to Solution.
what I would do is drop thae email string and do a people picker and have the ability to select more than person. If your bringing back a type person you have more flexibilty and it will not have all the crazy html that SharePoint adds to email Strings.
Previously, with this kind of issue, I have used a people picker column. Set the display format for the column to email. And I would add a small on-change Nintex workflow to copy the contents as text to a plain text column.
Not a problem to do this. My guess is that you've got an external email address in your list so SharePoint online/o365 is complaining about this because it doesn't like sending outside the organisation. The magic option to tick in the send email action is the "External email and attachment" option. That will allow you to send both inside and outside the organisation.
Naturally your to/cc/bcc fields will reference a single line of text field that you have delimited using semi-colons.
This is a bit of an old thread, but I had this same issue and Chris Ben's solution does work, HOWEVER, it requires that the semicolon delimited field have NO SPACES in it.
FAILS: firstname.lastname@example.org; email@example.com
Spent way to many hours banging my head against the wall before I discovered this, so I'm sharing to help others out. In my case, I was using a "single line of text" field.