send all data for selected code by auto mail

[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.