Send email to multiple recipients from output to gmail

[Eve_Yeager]

1. Capture Results column in excel and store it in “results” variable.
2. Capture EmailAddress column in excel and store it in “emailaddress” variable.
3. for each row, If “results” = “Yes”, then send an dynamic email.

How can I execute these steps?
Thanks in advance!

Here’s my excel:

[Anil_G (Anil Gorthi)]

@Eve_Yeager

Welcome to the community

1. Use excel file activity and then inside use for each row in excel
2. Inside than use if condition Currentrow.ByField("Results").StringValue.Equals("Yes")
3. On then side use send mail and Currentrow.ByField("EmailSddress").StringValue for address and give a body and subject as needed

Cheers

[fernando_zuluaga]

Hi @Eve_Yeager

We can avoid the validations filtering the datatable before looping, in this case use a filter datatable activity, pass the Result = “Yes”, it will keep just the neccesary rows, then we can loop through the result datatable and send the emails like this

Regards

[Eve_Yeager]

@fernando_zuluaga

tatable before looping, in this case use a filter datatable activity, pass the Result = “Yes”, it will keep just the neccesary rows, then we can loop through the result datatable and send the emails like this

Thank you! Do I need to change configuration on the properties to make sure the UiPath can communicate to my outlook to send the email and vice versa?
Here’s what the properties look like:

[Eve_Yeager]

Thank you! Do you know if I need to change some configuration in the properties section to make sure UiPath can communicate with my outlook?

[fernando_zuluaga]

Hi @Eve_Yeager

you just need to be logged in and outlook should be open as well, in the activity properties, just specify the account email that is logged

Regards

[Anil_G (Anil Gorthi)]

@Eve_Yeager

If multiple accounts then specify the account else it would take the default account

And yes outlook should be configured on machien and shpuld be open

Hope this helps

Cheers