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

Cross-posted at https://www.mrexcel.com/board/thread...lp-me.1201410/

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.

excel-sample.jpg

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

I have added the link because you are new.

We have nothing to do with MrExcel. You will have to get help from them to delete a post.

However, there is no reason for you to delete it. I have provided your cross-post link and that is all that is necessary.

If you care about the value changing in Buy or Sell then we need to see the formulas in those columns. VBA cannot detect if the result of a formula changes. It can only detect if a user edits a cell. So we have to work backwards from those formulas.

There's not much useful information in a screen shot. Please see "HOW TO ATTACH YOUR SAMPLE WORKBOOK" in the yellow banner at the top of the page and attach your actual file (it's easier to attach the Excel file than to take a screen shot and attach that).

Hello 6StringJazzer,

Please find the attachment. Sorry for delay.