Need a vba macro which can send mail for particular status

[rajasekhar]

hi Experts,



I have summary sheet in which for one particular status in column D if any status Begins and ends with Out of Scope - Out of Scope
Then it should using the company codes in column c send the mail to user in outlook along with variance amount which is found in E column



Mail format should be as follows.

Hi Users,

There is variance in between company codes -------- for the amount -------

Please fix this as soon as possible.

Thanks,
Gopal