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
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.