RE: Mailbox analysis - Need some help Nad Surf 31.Aug.12 01:56 AM a Web browser Domino Administrator All ReleasesWindows 2003
In what database have you put your agent and what is the trigger?
Is it scheduled or run from the action menu?
I had the same request some time back. The way I did it was to create an agent in the address book (run from action menu) that ran on selected person documents and exported the info to excel. I have removed the excel code part since you are putting the information in documents. The info I had to export is different from yours but you can easily modify my code to suit your needs. Here is my code:
On Error GoTo errorhandler
Dim db As NotesDatabase
Dim i As Integer
Dim dc As NotesDocumentCollection
Dim doc As NotesDocument
Dim serverName, filepath, firstName, lastName As String
Dim maildb As NotesDatabase
Dim size, sizequota As Double
Dim session As New NotesSession
Set db = session.Currentdatabase
Dim ws As New NotesUIWorkspace
Set dc = db.Unprocesseddocuments
If dc.Count=0 Then
MsgBox "No documents selected!"
Print CStr(dc.Count) " documents to process!"
For i=1 To dc.Count
Set doc = dc.GetNthDocument(i)