I am trying to use Excel content to send an email.
The content is as below :
The recipient is the owner (Column C)
I want the robot to look in column C and if they all match, then, copies all “Column A” to an email and send to Owner along with a massage I write in the body.
So the table should look like:
and example Email something like:
Appreciate your help.
This post might help you to get a list of all the duplicate rows.
For sending it in an Email body - You can use send outlook email activity.