Dynamic Recipient in SMTP Activity - Process Builder

Hi All,

I am trying to use the SMTP Activity in my application. My workflow generates a dynamic group using a auto activity, now I want to use SMTP activity after this activity such that it retrieves all the users in the previously created group and then sends a SINGLE mail to all members.

Is it even possible by using just configuration ? I am right now thinking of somehow mapping the email addresses to "TO" field of SMTP activity. But unable to connect the things dynamically.

Kindly suggest some pointers for the requirement.

Thanks.

Find more posts tagged with

Comments

Alvaro_de_Andres

Store the user's emails in a variable in a previous Read DQL activity and then use that variable in the SMTP variable.

MK_BV

Thanks Alvaro for the Quick response.

Can you please elaborate a little more on this. Correct me if wrong, you want to say that using DQL,

i get i_all_user_names from group followed by their email address.

How should I store multiple values in a single variable, I mean whether it should be comma seperated or semi colon seperated? Does the To field accept the value in such format?

Alvaro_de_Andres

Either

develop custom code that throws the dql, gets the repeating values, concatenate thems and then return a string

or (and usually considered best-practice):

loop through the results (ie: store the result of a count(*) and then query each repetitive atttibute)

Take a look to