I have a working VBA script that checks the sent items folder to see if there are items there from a specific date and then fires off an email to me with the status. However, I need this script to run automatically every day and I can't think of a way to do that. Any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Running a VBA script every day automatically in Outlook 1
- Thread starter utahjzz98
- Start date
- Thread starter
- #3
Thanks for the suggestion. I have looked into the event model in VBA. I am still hitting a little bit of a road block trying to think of which event to use. I found the ItemSent event which is used after something is sent. However, I just need something to fire off at a particular time each day. Do you know of anything like that off the top of your head because I can't find anything thus far?
- Thread starter
- #4
I have been looking at using a reoccuring appointment item hat fires off at a certain time every day and then sending an email based on that event firing. Thus far I am unable to find the mehtod/event that is triggered when the appointment reminder pops up on a user's screen. I think I'm on the right track but if anybody knows a better solution I would welcome it.
-
1
- #5
- Status
Similar threads
- Locked
- Question