I have a routine that sends emails when certain criteria are met. This works fine, but I would like it to not send anything if the Days >10. Any thoughts? Thanks for you assistance.
'Compose message
If Days > 0 Then
Msg = Recipient & vbCrLf & vbCrLf
Msg = Msg & "This is a reminder that the "
Msg = Msg & Document
Msg = Msg & " is due to be filed in "
Msg = Msg & Days
Msg = Msg & " days."
ElseIf Days < 0 Then
Msg = Recipient & vbCrLf & vbCrLf
Msg = Msg & "This is a reminder that the "
Msg = Msg & Document
Msg = Msg & " is now overdue and requires immediate attention."
End If
Bookmarks