Send emails with Filtered Dynamic Data from Excel

Help StudioX
,
1

Hello,
I am trying to create my first task, which reads email addresses from each Excel row and sends an email. I’ve created the sequence as per the attachment, but it doesn’t work due to an error with the Read Range activity.
The automation will also need to copy data from another column and paste it into the email body, but for now, I’m focusing on the first step.
Could you please help me with this?

Single Excel Process Scope
Single Excel Process Scope1250×1560 113 KB

UI Path Consolidated CIP Report - 2341 copy.xlsx (1.3 MB)
2025-05-15 14_00_30-C__Users_te556525_OneDrive - TE Connectivity_Documents_UiPath_CIP report out_Run
2025-05-15 14_00_30-C__Users_te556525_OneDrive - TE Connectivity_Documents_UiPath_CIP report out_Run984×552 14.4 KB

2

@piotr.skrobacz

  1. When you use foreach no need of read rand at all you can remove it
  2. Make sure you indicate the correct sheet in for each row in excel

Cheers

3

Thank you for the feedback, @Anil_G. I had previously tried doing it without the Read Range function, but it only iterated through the first row and ignored the others. Do you see any other potential errors here?
Thanks a lot!

Single Excel Process Scope
Single Excel Process Scope1250×1359 95.6 KB

Main.xaml (16.8 KB)

4

@piotr.skrobacz

Your send email also should be inside for each else only one mail would be sent..if you need

one mail for each row then it should be in the loop

Hope this helps

Cheers

5

thanks a lot @Anil_G , it worked!

1 Like
6

@piotr.skrobacz

Glad it helped

Happy Automation

cheers