How to trigger a vba script, if an email arrives, is send or an email is moved from one folder to another folder (via the outlook GUI)?

I was very very disappointment that I could only trigger a script for incoming mails and NOT for sent mails or moved mails via the GUI.

So I decided to investigate if it was perhaps possible to create the desired rules via VBA using the outlook.rule object. NoWay :(

I did have a look here

'https://learn.microsoft.com/en-us/office/vba/api/outlook.olruleactiontype

'https://learn.microsoft.com/en-us/office/vba/outlook/how-to/rules/specifying-rule-actions

Result:

'Start a script olRuleActionRunScript No (programmatically) Yes (Receive rules) No (Send rules)

'=> No Change to define a send rule which triggers a script neither via the wizard or via VBA

'olRuleActionNewItemAlert Yes Yes No (Send rules) '=> No change to have an Alert in case of a new message 'olRuleActionMoveToFolder Yes Yes No (Send rules) '=> This is an action not an alert (and not related to send)

So also this route seems to be dead

Perhaps you can help me a bit. I did take another look at the link you send and are confused.

The sub below seems to be a sub to send a mail. An action done by the user in my scenario

Sub SendMyMail() 
 Set myItem = Outlook.CreateItem(olMailItem) 
 myItem.To = "Dan Wilson" 
 myItem.Subject = "Data files information" 
 myItem.Send 
End Sub

This sub feels like a sub to put a send mail action in an event list
to send the mail at 2/2/2003 
Private Sub myItem_Send(Cancel As Boolean) 
 myItem.ExpiryTime = #2/2/2003 4:00:00 PM# 
End Sub

So I am confused ..

Related to the lastupdate time, I did test that (I hope I did not make mistakes), but moving an item to another folder seems not to change the 
update time :( . I just home that I am mistaken. 
Dim LastUpDate As Date
LastUpDate = mailobject.LastModificationTime
Would not help any way, since that is asking info from an object, which I was searching and not yet have located

Tja the restrict filter .... I did some testing with that one .... and IMHO it is a drama for a couple of reasons:
- a date will never match since the outlook internal timestamp has an higher precision than the date format,
so it will never match. A work around is to search for a value between two timestamps
- searching for a text in e.g. subject is impossible since the query does not handle modern (not basic ascii) in correct 
and you can not escape every potential special character. Not if you know the search string in advance and not at
all in case the search sting is unkown is inside a  string variable
- the used date sting format ... lets say I do not like it
But I worked around that by using the restrict function as minimal as possible and not for strings

1. The links I provided are for Events (Outlook calls your code when something happens) not Methods (your code tells Outlook to do something).
2. I'm not sure why LastModificationTime is not what you want. See:

Meanings of e-mail timestamps in MS Outlook VBA

3. You can use Outlook restrict/filter/sort features to work with a group of items. See:

extract the last updated timestamp from outlook item

Not sure I had a look at the link you provided on question b) solves my problem. I can trigger all kind of actions from VBA including sending or moving mails. That is not the problem. The problem is that I need triggers for events started by the user. Like sending a mail or moving or deleting mails.

Related to c). No I do not know which email (or folder) the user will be moving. So I need a trigger (including the mail key / item reference) to sync my database and perhaps starting some action.

At this moment the only option I have is to walk along all outlook mails to see what has changed, which is of course terribly inefficient.

Note that the it is most likely but not guaranteed that mails have been moved from the inbox of send item box, but you can not be sure about that.

b)
https://learn.microsoft.com/en-us/office/vba/api/outlook.mailitem.send(even) **** https://learn.microsoft.com/en-us/office/vba/api/outlook.items.itemadd

c) Assuming your know which target folders you want to monitor for items "moved" into them. Items.Item.Add Event. Same for the Delete Items folder.