Sending multiple emails to multiple recipients and attach one row per one email address

[kkkim]

Hi, Everyone!

I am trying to send one record (or one row of data in table format) to one email address. 

For example, below details will be in the table:

Name	Age	Address	RSVP	Date	Email Address
John Smith	42	1 Apple St	Yes	1/1/2022	john@apple.com
Mary Jane	35	2 Apple St	No	2/1/2022	mary@banana.com
Adam Doe	32	3 Banana St	Yes	3/1/2022	adam@cherry.com

Email will be sent to individuals with their data only. An example of outcome:

Sent to John Smith's email address:

Hello:

Please confirm your details below:

John Smith

42

1 Apple St

Yes

1/1/2022

Sent to Mary Jane's email address:

Hello:

Please confirm your details below:

Mary Jane

35

2 Apple St

No

2/1/2022

Any ideas on how to do this?

Thank you for your valuable input and guidance!!!

[Felipe_Ribeir0 · Accepted solution]

Hi @kkkim 

One way of doing this, just properly configure the connection parameters of the email tool.

[kkkim]

Thank you this worked!!!

[Kketan24]

Thank you.

I have another scenario where I want to Group By "Name" and don't require the Email Address Column in the table. Any suggestions?  

Name	Age	Address	RSVP	Date	Email Address (Not required in the table)
John Smith	42	1 Apple St	Yes	1/1/2022	john@apple.com
Mary Jane	35	2 Apple St	No	2/1/2022	mary@banana.com
John Smith	42	1 Apple St	No	3/1/2022	john@apple.com

Thank you.

[prpanw]

it is great. Can you also please suggest  how twe can attach table in  between of email body like below :-

Hi 

Please find the attach table for unpaid premium:-

Table attach

If you requird anything form end please let me know 

Regards,

MI Team