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
abc@gmail.com aaa CA 123
abc@gmail.com bbb TX 223
xyz@gmail.com 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 abc@gmail.com

Name Location Number
aaa CA 123
bbb TX 223

For xyz@gmail.com

Name Location Number
ccc NJ 333

so on...

Thank you in advance for the help