Get email address from SQL and send email
I am using a SQL integrator which gives me data in format: user name, user email and has 10 rows.
I need to iterate thru this SQL output and send emails individually to the above 10 users.
For ouput I am expecting that workflow will send email to user1 from row1 then move to row2 and send email to user2 from row2 and so on..
I am using "For each element in collection" componnet. >> is this the correct component to iterate SQL table row by row?