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:

[TABLE="width: 580"]
<tbody>[TR]
[TD]Email
[/TD]
[TD]Name
[/TD]
[TD]Location
[/TD]
[TD]Number
[/TD]
[/TR]
[TR]
[TD]abc@gmail.com
[/TD]
[TD]aaa
[/TD]
[TD]CA
[/TD]
[TD]123
[/TD]
[/TR]
[TR]
[TD]abc@gmail.com
[/TD]
[TD]bbb
[/TD]
[TD]TX
[/TD]
[TD]223
[/TD]
[/TR]
[TR]
[TD]xyz@gmail.com
[/TD]
[TD]ccc
[/TD]
[TD]NJ
[/TD]
[TD]333
[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 435"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Location
[/TD]
[TD]Number
[/TD]
[/TR]
[TR]
[TD]aaa
[/TD]
[TD]CA
[/TD]
[TD]123
[/TD]
[/TR]
[TR]
[TD]bbb
[/TD]
[TD]TX
[/TD]
[TD]223
[/TD]
[/TR]
</tbody>[/TABLE]

For xyz@gmail.com

[TABLE="width: 435"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Location
[/TD]
[TD]Number
[/TD]
[/TR]
[TR]
[TD]ccc
[/TD]
[TD]NJ
[/TD]
[TD]333
[/TD]
[/TR]
</tbody>[/TABLE]


Thank you for your help.