How to add semicolon after each value in email address column


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


Can you try ForEachExcelRow and SetVariableValue as the following?

It’s mostly same approach of the following post.


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())

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


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