Hello,
I am trying to figure out an automated way to send out an email based on the date in a column. As an example, if the date in column c has passed today's date then I need excel to remind me daily that the date has passed in email. I have done some research but I cannot seem to get it working for some reason. The macro I have works properly if I initiate it from excel but I am needing windows to automate it every morning. I think the best way is to setup a windows task that opens a notepad named VBScript and runs the macro to send the email every morning. I have never done it before so I may be doing something incorrectly.
To set this up I done the following:
1. Opened notepad and added the below script to it.
2. Named the notepad doc 'Macro.VBScript'
3. Set windows task manager to open Macro.VBScript every morning so it will initiate 'Email' macro.
A caveat is that I am connected to a shared network/drives and the spreadsheet that contains the macro is on a shared drive. The 'VBScript' file is also on a shared drive. I am trying to initiate the task from my work computer which may be causing the problem.
Hopefully I explained this properly but any help or suggestions would be very appreciated.
Here is the script I added to notepad for windows task manager to open:
Bookmarks