Solved: Send an outlook email by reading from cell values

[Arun]

Hello Gurus,

I am in need of sending emails from excel , where i have two columns A have person's name , column B have email id of person and column c with score of person. (attached is sample excel)

I want to send an email to every person listed in the sheet such that subject is a template - "<<A>> your score is <<c>> for the Quiz" (i.e. Arun your score is 20 for the Quiz" by reading the values from row 1 to 200 with the use of VBA/Macro.

Plz help me.

Thanks in advance. please help.