I have a comma separated list of emails in a single field. I want to send 1 email to each email address summarising the information in the form.

Eg

Row Num	Email recepients
1	test@test.com, bob@test.com
2	bob@test.com
3	Test@test.com
4	test@test.com

I want Test to receive 1 email with 3 entries and Bob to receive 1 email with 2 entries.

Constructing the email content is fine but I am having issues 

1. Extracting the emails from the comma separated field
• I don't think Zoho has an explode type function that can separate each value into a list item. How can I achieve this?
2. Getting the distinct emails from the list

The reality is that the form contains hundreds of rows and emails and sending out an email to each row is not acceptable.