You are viewing limited content. For full access, please sign in.

Question

Question

send email to multiple users using Query Data token

asked on May 5, 2016 Show version history

Hello-I need to send single email to all users specified in the multi-valued field.

I tried to use the Query Data token for email addresses but it says no multiple values supported.

How can I make this work? Thank you.

0 0

Answer

SELECTED ANSWER
replied on May 6, 2016

No, that's not going to work, that's just the first row from your query results. You have to process each row separately and add its value to the token.

3 0

Replies

replied on May 5, 2016

Query Data does not generate multi-value tokens. It generates a results set that you can go over with For Each Row. Within each row, the tokens corresponding to the columns in your query are single-value.

If you want a single email to all the people returned, you can create a multi-value token and collect all emails in it as you iterate through For Each Row.

0 0
replied on May 6, 2016

Thanks Miruna. I have created the token before the email activity hoping that it will capture up to three user emails but did not work.. Is this how I should have set the token as?

Thanks, Aya

 

0 0
SELECTED ANSWER
replied on May 6, 2016

No, that's not going to work, that's just the first row from your query results. You have to process each row separately and add its value to the token.

3 0
You are not allowed to follow up in this post.

Sign in to reply to this post.