VBA - Send email - Rows in the body of the email

[Mahesh Babu]

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

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

1 email for each Unique mail id. Output should be as follows:

For abc@gmail.com


Email Name Location Number
abc@gmail.com aaa CA 123
abc@gmail.com bbb TX 223



For xyz@gmail.com

Name Location Number
ccc NJ 333

Thank you for your help in advance.

Regards,
Mahesh Babu

 

[Chihiro]

Check link. I'm sure you'll find what you need there.

https://www.rondebruin.nl/win/s1/outlook/mail.htm