Need a vba macro which can send mail for particular status

[rajasekhar]

Raja,

Welcome to ExcelFox.

Can you explain where the mail IDs are listed?

its in contact list complete i attached the same please find it.

let me tell you in brief i have three columns out of which if i have status with Out of scope - Out of scope in column d for example D7 in Data work book in summary sheet which is attached in earlier post.

i need to take the company codes copied from column C 2053 & 1063
And pull the user mail ids from contact list and also pick the amount from D column and send the mail to user in this format

Hi User,

There is discrepancy between Company codes 2035 & 1063 with a variance of 289

Please fix this as soon as possible.

Thanks,
Raj

[rajasekhar]

Please provide the solution its bit urgent. and sorry for troubling .