VBA to send email to unique mail id given in a cell with the subsequent columns

[Prince27]

Hi,
There are 4 columns in excel as shown below:

Email	Name	Location	Number
abc@gmail.com	aaa	CA	123
abc@gmail.com	bbb	TX	223
xyz@gmail.com	ccc	NJ	333

<tbody>
</tbody>

I need a VB Code to send separate emails to unique mail id's with column 2, 3 & 4 in a table format.(Mails should automatically send to mail id's given in column1)

1 email for each Unique mail id.


Output should be as follows:

For abc@gmail.com

Name	Location	Number
aaa	CA	123
bbb	TX	223

<tbody>
</tbody>

For xyz@gmail.com

Name	Location	Number
ccc	NJ	333

<tbody>
</tbody>

Thank you for your help.