I'm horrible with for / next loops.
I've got code that emails a notification and adds cell data to the body of the message (thanks to the board for info on that). I've already set up the sheet to add 'PAST DUE' when a date is past.
Now I want cycle through the sheet to look for "PAST Due" in Column N and send an email with data from Columns C, J, and K. I know where it goes (to be done upon opening the sheet). I just need the before and after stuff to do the cycling. I'm pretty sure the body of the email would be a variable instead of Range("cell").Text as part of the cycling. Any help would be greatly appreciated.
I've got code that emails a notification and adds cell data to the body of the message (thanks to the board for info on that). I've already set up the sheet to add 'PAST DUE' when a date is past.
Now I want cycle through the sheet to look for "PAST Due" in Column N and send an email with data from Columns C, J, and K. I know where it goes (to be done upon opening the sheet). I just need the before and after stuff to do the cycling. I'm pretty sure the body of the email would be a variable instead of Range("cell").Text as part of the cycling. Any help would be greatly appreciated.