I have the below table
I want to email in draft for each report
so, from below I want 4 emails to be created
each email will go to different people lets say a@gmail.com, b@gmail.com , c@gmail.com and D@gmail.com
how can i use this table and have multiple email created in draft so that it can be checked before sending it out?
Thank you for your help
| Report | Seq | Date | Value | No | A | B | C | D |
| 1 - Report | 1 | 11/25/2022 | 10 | 3.26 | | | | 102 |
| 1 - Report | 2 | 11/25/2022 | 20 | 3.19 | | | | 0 |
| 2 - Report | 1 | 11/25/2022 | 10 | 4.48 | | | | 103 |
| 2 - Report | 2 | 11/25/2022 | 20 | 4.36 | | | | 0 |
| 2 - Report | 3 | 11/25/2022 | 30 | 2.42 | | | | 0 |
| 3 - Report | 1 | 11/25/2022 | 10 | 1.49 | | | | 0 |
| 3 - Report | 2 | 11/25/2022 | 20 | 1.3 | | | | 0 |
| 4 - report | 1 | 11/25/2022 | 10 | | 2.14 | 0.27 | 6.04 | 0 |