I am currently trying to add an if statement into some code in a macro design to send automated emails every day. Currently the macros runs great except now I am being asked to have the emailed data go out for the previous month if the day of the month is less than or equal to 5. Our company has a roll over date of 3 business days to get all data in for the prior month before closing the books. With the weekend this is where the 5 days works out perfectly. My code in the macro is shown below. I believe all variable are self explanatory but if not let me know and I can clarify. When I type this code in the macro and hit ok I get an error message that is shown below.
