Excel VBA-- send email with a specific column line changes and the rows associated with it

[Hkaur93]

I need to send an automated email every time a status in Column B changes to "Active" I also need it send Column E & Column H text that is associated with the the row in Column B that was changed.

 

[mumps]

Is the email address in one of the columns? What about a subject line? Do you want to send the email immediately or do you want to review it before sending it? It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).