Send email from Excel using Outlook

Originally Posted by clapforthewolfman

' If Date - Worksheets("Monitoring Information").Range("A:A") <= Today() + 7 Then (I would like to add this code but I get a compile error that the sub or function is not defined)

This is referencing all of column A. Its also missing a property. Which Range (cell) are you trying to compare today's day plus 7 (days?) to?