VBA to send unique email

Hi,

Need VBA to send unique email from ranges of cells and respective range of cells as a table in the body of the email as shown below.

There are 4 columns in excel as shown below:(Email, Name, Location, Number)

Email Name Location Number
aaa CA 123
bbb TX 223
ccc NJ 333

I need a VB Code to send separate emails to unique mail id's with column 2, 3 & 4 in a table format as body of the email

1 email for each Unique mail id.

For

Name Location Number
aaa CA 123
bbb TX 223

For

Name Location Number
ccc NJ 333

so on...

Thank you in advance for the help