Hello guys,

I urgently need help with something. I am relatively new to Excel programming and would really appreciate your help. I am trying to build a program that automatically sends email of the 5 oldest records. I was able to create the auto email sender and it works but can't seem to just choose the 5 oldest one.

I am attaching the file. I need to choose dates from the column C and I will be adding more record along the way, that's why the range option may not to be the best one.

Please take a look and let me know if you have any questions.

Thank youTest1_CSA.xlsm