Hi,
I need help on how to write a Macro to do the following:
1) In the Sample sheet attached, if any Cell from C4:E6 changes to <=5, then a mail needs to be triggered from Apple Mail.
2) The Subject of the email needs to contain a "Message" + below details :
A) Branch Name (based on which Branch Cell Row has changed) &
B) Product (based on which Product Cell Column has changed)
3) The email body should contain a message + the Cell Value which has changed to 5 or below.
Pls note that I am using MAC & my email account is configured on Apple Mail.
I would really appreciate if someone can help me out here.
Thanks,
Nishit.
Bookmarks