RE: MS Outlook goto Send Items and Run Rules every 4 hours
In short I am so bad at this. I have searched for weeks trying to find a script and make it all come together, even the bits I get right failed when I try to put them together so I am too embarrassed to show what I have tried.
I have multiple folders for each claim/client.
I set rules for incoming emails that automatically go to folders I create based on various subject references.
the problem is every few hours I must go to the sent items folder and manually run the rules so that the rules I have created will sort all the sent emails also into the respective folders.
we work on MS exchange off a single email, so my buddies need me to get the sent items into there folders regularly (also am out the office for meetings).
from what I see it needs the following:
1. loop - every 2 hours it should run (prefer during 6am and say 10pm)
2. goto Outlook window (and not be bugged if I am busy on another window - happy if I am overruled by this script)
3. run the VBA macro t goto send folder I created
4. run a second vba macro that runs rules that i created
1. Loop - yoah!! tough
no ideas how I will employ this
2. goto Outlook window
I have tried the following with partial success
Code: Select all
Process, Exist, OUTLOOK.exe
If (!ErrorLevel){
Run OUTLOOK.exe
WinWait, ahk_exe OUTLOOK.exe
}
WinActivate, ahk_exe OUTLOOK.exe
Return
#IfWinActive ahk_exe OUTLOOK.exe
{
Send !6 [alt6 is a shortcut to the VBA script that is on quick access toolbar]
}
#IfWinActive
3. run the VBA macro to go to send items folder
Send !6 [alt6 is a shortcut to the VBA script that is on quick access toolbar = works great]
4. run a second vba macro that runs rules that i created
Send !5 [alt5 is a shortcut to the VBA script that is on quick access toolbar that runs rules = works great]
apologies in advance
Mike