Lotus Domino - find "from" for email

Hi,

I have this code going through the email doc in domino

       For Each it In docMailItem.Items
        Debug.Print it.Name
        Debug.Print it
        ' or get the value in any other way!
       Next it

I see the it.Name as being all the fields that I need, such as Subject and From, but I can not get to the value. Please help. Thank you.

As a background, here the code leading to it. It all works.

   Set colMailItems = Maildb.AllDocuments
   Set docMailItem = colMailItems.GetLastDocument
   NumberOfMessages = colMailItems.Count
   ReDim aryContent(NumberOfMessages)
   blnReadMailRunning = True
   For lngItem = 0 To NumberOfMessages - 1
       Open storePath + "/email_" + CStr(lngItem + 1) + ".txt" For Output As 1
       Open storePath + "/email_" + CStr(lngItem + 1) + ".prop" For Output As 2
       
       itmMailItem.Authors = Join(docMailItem.Authors)
       Print #2, "Name=From"
       Print #2, "Value=" + itmMailItem.Authors
       
       If TypeName(docMailItem.Body) = "String" Then
            itmMailItem.BodyText = docMailItem.Body
           
       Else
           itmMailItem.BodyText = Join(docMailItem.Body)
           
       End If
       Print #1, itmMailItem.BodyText
       
       itmMailItem.LastModified = docMailItem.LastModified
       itmMailItem.Size = docMailItem.Size
LVL 1
kerznerAsked:
Who is Participating?
 
Richie_SimonettiConnect With a Mentor IT OperationsCommented:
or, if you prefer:


For Each it In docMailItem.Items
        Debug.Print it.Name
        Debug.Print it.text
        ' or get the value in any other way!
       Next it
0
 
Richie_SimonettiIT OperationsCommented:
msgbox docMailItem.columnvalues(1)
0
 
kerznerAuthor Commented:
Sorry, Richie, you ARE the expert, I know, but I get

Object doesn't support this property or method
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
kerznerAuthor Commented:
Hooray! Debug.Print it.text worked
0
 
Richie_SimonettiIT OperationsCommented:
Then, the problem is with docMailItem, it is not a NOTESDocument object, isn't it?
0
 
Richie_SimonettiIT OperationsCommented:
If you have an object reference for each document in AllDocuments view, then, one of its properties is .columnvalues which is an array.
0
 
kerznerAuthor Commented:
no, of course not. I know that this is an old library I am using, but I have the code, and it is already working, so be it for now

when I re-write, I will probably use Java anyway

Best regards.
0
All Courses

From novice to tech pro — start learning today.