Outlook macro to check a value of a cell in an attachment and send an email based on that value

[ketangarg86]

Hi,

I am very new to Outlook macros and was thinking to automate and better manage my mails. Could you please help me out.

1. I want to write a macro that reads the value of a cell in the excel attachment of a mail. The mail is standardised and so the attachment name and the subject of the mail will remain the same.
2. After reading and checking the value of that predefined cell, I want to send an email to more people only if the value of that cell is greater than 20, for example.
3. Is there a way the macro kicks in automatically when such email comes.

Other than that, is there any other way apart from a macro that I can achieve my goal.



Thanks again and I really appreciate your help.

Thanks
Ketan