I have a sheet like >
NAME | Apples | Oranges | email
Zak | 2 | 1 | Zak@zak.com
Zak | 3 | 6 | Zak@zak.com
Zak | 1 | 2 | Zak@zak.com
mika | 2 | 1 |Mika@zak.com
mika | 3 | 6 |Mika@zak.com
mika | 1 | 2 |Mika@zak.com
and i want to do " if apples > oranges = email name"
And i did this by “for earch row” → " if apples >oranges" then “email name”
but what i would like to do, is rather then send an email per row, is send 1 csv to zak, and 1 csv to mikam each containing the relevant row data
You could add the data from each row in a separate datatable and then send it by email.
Thanks Ovi, im not really sure how I would do that ? I know ive given an example of 2 names, which means 2 csvs, but eventually i will need to be able to apply this to many names that change per report etc.