How to add semicolon after each value in email address column

Help StudioX
, , ,
1

Hello,

I want to add a semicolon after each individual email so I can copy and paste it into the Outlook “To” bar. I am using Studio X.

Any help is appreciated. Thanks
image

2

Hi,

Can you try ForEachExcelRow and SetVariableValue as the following?

image
image728×469 21.3 KB

It’s mostly same approach of the following post.

Regards,

3

Hi ,

If the use case of adding the semicolon to end of each column is only for the purpose of To in outlook , then you can use the following linq query at the time of To email address.

ToEmailAddress= String.Join(“;”, dt.AsEnumerable().Select(Function(a) a(“Personal Employee Email”)).ToArray())

4

Thanks for your help. This was the solution that worked. I had to remove “ToString”.

image
image1056×632 31.3 KB

Best

5

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