VBA - Loop/Filter and Send Email

[eddymx]

Hi,

i want to do the following, from the table below i want to:

1-Filter per column C for unique values
2-Once filtered if its only "1" row, then put each cell on that row into a variable.
3-Once filtered if the results is more than 1 records, meaning the same email address has 2 or more records then grab all the range from A to E (range to HTML).
4- Paste the information in an Email (outlook app 2010).
5-Loop until column B hits a blank cell, which means its the end.

Table Example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Record ID[/TD]
[TD]Email[/TD]
[TD]Data[/TD]
[TD]Data[/TD]
[TD]Data[/TD]
[/TR]
[TR]
[TD]Record1[/TD]
[TD]test1@test.com[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Record2[/TD]
[TD]test2@test.com[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Record3[/TD]
[TD]test1@test.com[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

At the end, the following emails should be sent or display:
1- One email with 2 rows with all columns from A to E to test1@test.com in a range to Html.
2- one email with 1 row with all columns from A to E to test2@test.com in variable then paste them into HTML.

i need the VBA logic since all the examples i have been reading doesnt fit this exact way i want to do it.

Thank you so much for reading!