cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Email multiple addresses from field

Jump to solution

Hi,

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

name1@email.com; name2@email.com; name3@email.com

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.

<div class="ExternalClassA29E0AF28E9242049FDD5890B9D222AC"><p><a href="mailto&#58;name1@mail.com">>name2@mail.com</a></p><p>&#160;</p></div>

How can I correct this problem? Any help is appreciated!

Labels: (1)
Tags (1)
0 Kudos
Reply
6 Replies
Workflow Hero

Re: Email multiple addresses from field

Jump 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.

0 Kudos
Reply
Workflow Hero

Re: Email multiple addresses from field

Jump to solution

Can you confirm that the text column is set as 'plain text' and not as rich text?

0 Kudos
Reply
Workflow Hero

Re: Email multiple addresses from field

Jump to solution

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.

Reply
Workflow Hero

Re: Email multiple addresses from field

Jump to solution

Hi Shanan,

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.

Cheers,

Chris

Reply
Workflow Hero

Re: Email multiple addresses from field

Jump to solution

Thanks ‌ I've set the field as 'Multiple Lines' then set it as 'plain text' underneath that and it seems to work.

‌ I've set it as 'External' as default since the emails would be both internal & external. Thanks for the help!

0 Kudos
Reply
Workflow Hero

Re: Email multiple addresses from field

Jump to solution

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. 

examples:

FAILS: name@address.com; name2@anotheraddress.com
WORKS: name@address.com;name2@anotheraddress.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. 

Reply