Hi! I'm quite new to VBA so this task is kinda difficult to me.

I would like to automate a rejection process. It should look something like this using pseudo-code

Execute Marco:

For all rows

If (Row#,Column G)="ToBeRejected" //Column G marked if a candidate needs to receive a rejection mail

Do

Send Email(outlook) to [Row#, Column K] // Column K contains email adress

Change (Row#,Column G)="Rejected"

----------
In words, the marco show parse thorugh each line and automaticall send an rejection mail to each entry with status "ToBeRejected" with an Email

If possible In the Mail Body there could be a place holder for names like

Mail Body = "Dear" (Row#,Column E) "blablabla...."

Thanks a lot!!

Cheers

Han