that meets the correct criteria and populates with data but not when it goes back to an unpopulated cell.
Does the macro need to check the data for accuracy prior to sending the email/s ... or, can the email/s be sent anytime the cell has data within ?