I used your first file and added the macro:
CheckAndSendMail
This is the macro that needs to be called using the vbs script.
If you open the file nothing happens, it just opens so you can modify the file
There are no email addresses in it so it won't do anything.
The Send Mail macro is called from witinh that macro, you will have to wirte the text for the subject line and the mail body, I yous placed some text in it.
The mail send will NOT send yet, the .Sedn options is disabled, it will just Save and Display the message for testing.
The file is saved and closed upon completion.
Place a ' in front of Application.Quit to keep the file open while testing then do not forget to remove the ' and also activate the .Send and disable .Save and .Display
Hope this helps you on the way
Bookmarks