Monthly Email Macro

[rcduffe]

I was wondering if someone could help me with a macro that I had in mind of creating. I wanted to try and make a macro that on a certain date every month would send an email out to a specific email address. Then, if it has not been saved or opened by a certain date, to also send out an email. I think for the email I would use .sendmail recipients:="email address", subject: "blah blah" but I do not know how to send it on a specific date nor if it has not been opened or saved. Any tips or help would be greatly appreciated.

 

[rcduffe]

would this be how to get the macro to run monthly

If Day(Now()) = 1 Then
Call Run_on_First_Day_of_Month_Macro
End If