I am trying to get excel to send an email with data based on 2 columns. I want it to look at column c and it the date is equal to or earlier and column V does not have a date in it, then it will list data in the email. As I have it, it is checking column O to see if there is a date and not column V. I can't figure out why. Any ideas?
Dim strbody As String
Dim EmailTo As String, EmailCC As String, Subject As String, ClaimNo As String
Dim LastRow As Double, rcell As Range, tcell As Range
Dim NoDupes As New Collection