I need some assistance with a workflow process.
I have a spreadsheet of employee names, managers and managers email addresses.
What I’m trying to do is read all that data and then send an email to the corresponding manager of the employee, in the body of the email I’d like to include employee name(-s).
Hi @igoike ,
read the excel file and store it in a data table.
use for each activity to iterate between managers.
use send outlook mail activity inside the for loop .
you can include body and subject using this activity.
thank you for your reply, it’s not working the way I want it to, it sends an individual email per employee, I want it to group it by the manager and then in the body include all the employee names
Use filter data table to manager column… you can club it up and send mail