Dim Session As New NotesSession Dim db As NotesDatabase
Dim db2 As New NotesDatabase( "Server", "Database" )
Dim ws As New NotesUIWorkspace
Dim doc As NotesDocument
Dim doc2 As NotesDocument
Dim rti As NotesRichTextItem
Dim rtnav As NotesRichTextNavigator
Dim rtrange As NotesRichTextRange
Dim iCount As Integer
Dim vSplit As Variant
Dim NewDoc As NotesDocument
Dim collection As NotesDocumentCollection
Set db = Session.CurrentDatabase
Set collection = db.UnprocessedDocuments
Set doc = collection.GetFirstDocument()
While Not(doc Is Nothing)
'Set doc = ws.CurrentDocument.Document
Set rti = doc.GetFirstItem("Body")
Set rtnav = rti.CreateNavigator
Set rtrange = rti.CreateRange
Set session = New NotesSession
Set Newdoc = New NotesDocument( db )
Set doc2 = New NotesDocument ( db2 )
doc2.Form = "MainForm"
Newdoc.Form = "Memo"
If rtnav.FindFirstElement(RTELEM_TYPE_TEXTRUN) Then
Do
iCount = iCount + 1
Call rtrange.SetBegin(rtnav)
vSplit = Split(rtrange.TextRun, Chr(9))
If icount = 2 Then
doc2.ReferenceNum = vSplit(Ubound(vSplit))
Elseif icount = 3 Then
doc2.Title = vSplit(Ubound(vSplit))
Elseif icount = 4 Then
doc2.FirstName = vSplit(Ubound(vSplit))
End If
Loop While rtnav.FindNextElement(RTELEM_TYPE_TEXTRUN)
Call doc2.Save(False,True)
End If
Call session.UpdateProcessedDoc( doc )
Set doc = collection.GetNextDocument(doc)
Wend
All it does is to mail body contents to another database into specific fields…
Any help would me much appreciated
Regards