So, I’d like to lookup how many emails have been sent/received for a given email address and return a list of senders/recipients and a count of emails sent/received for each sender/recipient.
So far, my scenario provides a given email address. The next step is to search Outlook/Exchange which returns the emails found where the given email address is within the TO or FROM fields.
Where I’m stuck is how to build a table of results which performs a count. I’m close, however, where, say, an email TO field contains multiple email addresses, I am using an Iterator to do a count of each individual email address. This is fine to a point.
The question I have is, how do I total up the count where a recipient exists in multiple emails (bundles).
For example
email 1: From john@somewhere.com To: joe@abc, mike@xyz
email 2: From john@somewhere.com To joe@abc
email 3: From joe@abc To: john@somewhere.com
In this example, the email address to search is john@somewhere.com and I’d want a table showing:
joe@abc 3 emails
mike@xyz 1 email
The iterator contains 3 operations in this example (3 emails) and
2 bundles for operation 1
1 bundle each for operation 2 and operation 3
Is this enough info for some wise person to point in the right direction?
Thanks in advance
