Excel and outlook automation


how can i send an outlook mail to the list in excel as well as to other mail id with some condition like if the value is up to 100 it have to snd mail to x@gmail.com and if it is greatr than 100 and smaller than or equal to 200 than mail to y@gmail.com and if itz geater than 200 to other mail id z@gmail.com and also have to change the status in excel as processing one the mail is sent can any one help in this pleaseSample.xlsx (10.0 KB)