Automatically send email select rows if cell = "Buy" or "Sell". Kindly help me.

[kishan726]

I am new to VBA. I can't watch excel at all times. I need to get email notifications automatically from excel. I need VBA codes.

If cell value = "Buy" in Column Index AR, then automatically send email select rows subject = Scrip Name in Column Index C space Buy space High Break amount in Column Index AP and body message = Buy Notification at current time.
If cell value = "Sell" in Column Index AS, then automatically send email select rows subject = Scrip Name in Column Index C space Sell space Low Break amount in Column Index AQ and body message = Sell Notification at current time.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Automatically send email select rows if cell = "Buy" or "Sell". Kindly help me.
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.