Sending mail to multiple recipient using excel

[sanjay_gowda (sanjay k k)]

Hello,
I have an excel sheet in which a list of emails are added in a single cell I need to send email to all the recipient. If I use excel application scope and add read range then inside for loop I’m using mail activity. The thing is when automation comes to excel scope it is opening the excel and getting an error as excel is used by another application so how can I overcome this

Thank you

[Gokul001 (Gokul Balaji)]

HI @sanjay_gowda

Disable visible in the property of excel application scope and try once.?

Regards
Gokul

[Gokul001 (Gokul Balaji)]

here is the SS

Regards
Gokul

[pravin_calvin (pravin kumar)]

Hi @sanjay_gowda

Use workbook read range instead of excel read range!
Or

We can try with close workbook activity or kill process!

Regards

[nikhil.girish]

@sanjay_gowda
Drag a kill process activity

Under that process name mention “Excel”

So this kills any ongoing background processes of excel

Hope this helps