使用VBA根据数据点发送电子邮件

I am basically trying to send out an email if a certain data point is greater than or less than a max and min point respectively on the sheet. The thing is I set up the "If, Then" statement but it is not giving me the results that I wanted. Some text is even showing up and I am trying to only show the numbers that are in column "E". I wonder where I am going wrong. I will specify in the code where I think I am going wrong. Also I am comparing with "K26" and "K25" respectively for Max and Min. Thank you for your help!I am basically trying to send out an email if a