How to send email to multiple recipients in cc

Hi Guys,

I need to send a email to multiple recipients in cc.
I have email id’s(Busines_ID) in a excel as given below.
I will get a owner name in a variable. whenever the variable name matches with owner column in the given excel, corresponding email id’s i need to pick and split it into new line. so that i can send the email to those id’s in cc.

Here the business id column may be added with different email id also more then 4 could be added. So how can i dynamically get those id’s in CC

Can anyone let me know how to do this?

Thanks in advance!

image

Hi @vinutha1

Need a clarification ?
Is there Business_ID column always contains 4 email ids or else it varies

Thanks
Robin

@Robinnavinraj_S

it gets vary. 4 is not fixed it can be more then 4 also

Hi @vinutha1 ,

You can do like split the the values of Business_Id column with the new line or check where it splits, then join with semi colon(";") and save this in one variable. Pass this variable in cc.

1 Like

This sequence split the emails.
Test.zip (182.4 KB)

Regards!

1 Like

Hi @vinutha1

we can split email ids by using regex

create a string variable append all the output values of regex

pass that appended string variable into cc tab of send outlook mail message activity

Thanks,
Robin

@manjula_rajendran ,

Thank you so much …it worked!

1 Like

@Robinnavinraj_S Thank you for the help!

@Angel_Llull

Thank you!

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