Skip to main content
Nintex Community Menu Bar
Answer

Email multiple addresses from field

  • July 31, 2017
  • 6 replies
  • 423 views
S
Forum|alt.badge.img+7

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!

Best answer by shaunlub

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.

    6 replies

    B
    Forum|alt.badge.img+7
    • bstori
    • Novice
    • August 1, 2017

     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.

    S
    Forum|alt.badge.img+11
    • shaunlub
    • Scholar
    • August 1, 2017

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

    S
    Forum|alt.badge.img+11
    • shaunlub
    • Scholar
    • Answer
    • August 1, 2017

    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.

    Chris_Ben
    Nintex Employee
    Forum|alt.badge.img+14
    • Chris_BenNintex Employee
    • Nintex Employee
    • August 1, 2017

    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

    S
    S
    Forum|alt.badge.img+7
    • snathan
    • Author
    • August 1, 2017

    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!

    M
    Forum|alt.badge.img+3
    • mikeboggs
    • April 5, 2018

    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. 

    S
    M
    D
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement