Prepare string of email address

Help Activities
, ,
1

I have one datatable with column “Email”. I want to send only one email to all the email address present in “Email” Column. Please help me in composing the string of all the email addresses.

2

Hi,

You have to separate all the email address with semi colon so that we can send one email to all the email address available in that column of the data table.

eg: abc@xyz.com;bbc@xyz.com;acf@xyz.com

3

Hi @harshit.gupta

Please try this,

Read the data from excel using read range activity and store it in the datatable , variable name - dt

string.join(";",dt.asenumerable.select(function(d) d("Email").tostring).toarray.distinct().toarray())

Thanks

4

its also depending on the used send mail activity. some types do need the ; on end, others not …

5

Thankyou

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.