Vba code How to send an email to specific name which was named as ram in the worksheet .

[Shailender]

Hi All,

Vba code How to send an email to specific name which was named as ram in the worksheet . It should happen for all names which was named. And it should be done automatically for all the sheets in the workbook. After sending the email sheet should get delete automatically.

For reference I have attached the email.

Thank you!

 

[Shailender]

Can Anyone help me out....