We are using modusmail with the extended database. I want inactive (expired) users whose mailboxes get deleted to stop receiving mail until they login again through POP3. So I need two things, the first is to disable receiving mail by setting the the ACCESS_RECEIVE=0 when the mailbox expires. The second is to enable it when the user logs in. I am able to implement the second part by creating a trigger to set ACCESS_RECEIVE=1 whenever LAST_ACC_DATE is updated and it's working. However I am not able to identify the field to monitor that indicates the mailbox has expired. Is there any such field? Currently I manually run a query every now and then to find users who haven't logged in for long time and set their ACCESS_RECEIVE=1.
Thank you,
Adil
