Auto mail from excel (vba code)

[kv.singh]

I have a excel file having two sheets 1)Name 2)DATA
I want vba code for sending auto mails one after another to mail IDs in col. C of "NAME" sheet having "yes" remark in col. D
Code should fetch all corresponding rows from DATA sheet for Code(col.B of sheet "Name") and convert to html table
format in mail and send mail to corresponding mail address against code shown in "Name" sheet. body of mail and sample
mail result is shown in sheet "result"
I am using Microsoft outlook 2016 for sending and receiving mail.


I will be very thankful if anyone can provide code.

 

[Logit]

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

 

[kv.singh]

I am new to vba and urgent solution required to complete project.

 

[kv.singh]

kindly give some code