| Account No | Admt Date | Code | Status | Receipt No | Email Subject | Email Body | Mail ID |
| 123 | 18/03/2024 | 1100 | Active | 1111 | Hello - [[Code]] | Greeting of the day | abc@xyz.com |
| 456 | 17/03/2024 | 1560 | Pending | 2222 | Hello - [[Code]] | Greeting of the day | bnm@ppp.com |
| 789 | 19/03/2024 | 1560 | Complete | 3333 | Hello - [[Code]] | Greeting of the day | bnm@ppp.com |
| 1011 | 16/03/2024 | 1100 | Complete | 4444 | Hello - [[Code]] | Greeting of the day | abc@xyz.com |
Considering the above scenario, irrespective of the number of rows the workflow should do the following -
Send out emails by grouping the rows based on the code, therefore the rows with code 1100 will have an email below like this,
To: 'abc@xyz.com'
Subject - Hello 1100
Hi,
This email is being sent to 'abc@xyz.com', Greeting of the day
| Account No | Admt Date | Code | Status | Receipt No |
| 123 | 18/03/2024 | 1100 | Active | 1111 |
| 1011 | 16/03/2024 | 1100 | Complete | 4444 |
Thank you.
And the email should be sent to the mail id specified in its row - 'abc@xyz.com'
And also the Email subject or Email body needs to contain the ability to have Code or any parameter of the column which is same for all rows.
If the email subject contains - Hello [[Code]] then the email should be sent with the subject - 'Hello 1100'
PS - If there is any other column in the table which has same values for all the rows and if the email subject contains that column name enclosed within 2 square brackets, it must consider the row/variable value.
Similarly the 2nd table would look like the below,
| Account No | Admt Date | Code | Status | Receipt No |
| 456 | 17/03/2024 | 1560 | Pending | 2222 |
| 789 | 19/03/2024 | 1560 | Complete | 3333 |
And this mail would be sent out to 'bnm@ppp.com' with appropriate handling of values in email subject or in the email body as shown in the above example.
This should happen for any number of rows and columns.
Let me know if there are any more questions, confusions.
