It should be possible aith MTC (Message Tracking Stroe) if it is enabled in your environment. But I can’t be positive, it’s something I used a long time ago and don’t have any clear idea on that particular point.
Otherwise, you could use log.nsf the “Session” form documents. Scanning them by users and from the more recent to the oldest.
If you have Item BodyDatabase contains “mail.box” and item BodyDocsWritten contains something more than 0 then your users sent a mail.
Attention both items are not text list so parsing the values will not be as simple as
Pos = ArrayGetIndex(doc.BodyDatabase ,”mail.box”)
if not Isnull( Pos) then
if doc.BodyDocsWritten(Pos) > 0 then
‘we have a mail trace
LastMail(j,0) = doc.UserName
LastMail(j,1) = doc.StartTime
‘Jump to the next user
You’ll have to build arrays out of the items by splitting the values. the separator being one or many CR+LF entries (on a win platform) then you will be able to match the cells of each array.
Maybe with something like
ArrayDbs = split(trim(doc.BodyDatabase(0));chr$(13))
I am no sure it will work at all
Attention also that if you use multiple mailboxes, you’ll have to check for mail?.box in BodyDatabase item.
That’s the basic idea I would use in the same case, running that on all servers in my domain.
Hope this helps