How to generate email with a table in it?

[MohammedBurhaan]

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.

[Luke_C]

Hi @MohammedBurhaan 

You'll want to check out the reporting tools. This will let you create tables grouped by certain values, generate dynamic text for your emails, and send the emails out using the email tool. 

[binuacs]

@MohammedBurhaan another option is with batch macro

[rzdodson]

Here is another batch macro approach. For the Greeting of Day field, you'll just need to adjust the time parameters for the Formula tool to correspond with your preferences.