I have a excel file that is automatically being updated by Microsoft Access query on set times. At the end of the day I would like a email report sent out for every row only where the column of the hours applied (G) are .5 greater than that of their target column (H). Since it is Access I believe all the information is in text format including numbers.

Can anyone help me on how to enter a VBA or Macro and steps to email the information needed at 12am CST (midnight) Mon-Fri?

enclosed is a sample screenshot excel. certain information removed for privacy.


sampletrackeremail.png