I have a file that currently sends an automatic email if any cell goes above 20. If possible I would like to:
- Add the value of the cell that triggered the email in the first place.
- Add the part number for the row it is referencing.
- Add the defect type that is the column header.

Ex. The email would say, "Part Number 619793100B has 22 scrapped DIRT parts for the hour."

I was unable to attach the file. Suggestions would be greatly appreciated. I've hit a wall.