Hi everyone I am so sorry to bother you all.

I am trying to create a macro or write some code but I am not having a luck. I was able to create code that sends email and pulls info from text boxes but now that I need something a little bit more specific I hit a wall.

Anyways I have rows that go from A thru K. All cells in column J contain dates. What I want to do is either extract or send email containing the row, 10 days before today. Pretty much J is a due date I need to know 10 days before it goes past due and if it is past due to still include the row when the data is extracted or the email is sent. I did some conditional formatting and the cells turn a color .. but I would like to extract the rows so it is easier to look at the report.

Am I explaning myself right? I just need some guidance here.