Deleting Duplicate documents in a view.
Sub Initialize
Dim Session As New NotesSession
Dim db As NotesDatabase
Dim view As NotesView
Dim doc As notesdocument
Set db = session.currentdatabase
Set view = db.getview ("Daily Schedule")
Set doc = view.getfirstDocument
While Not (Doc Is Nothing)
Set wdoc = view.getnextdocument(doc)
If doc.salesrep(0) = wdoc.salesrep(0) And doc.weekstarting(0) =
wdoc.weekstarting(0) Then
Call wdoc.Remove.doc (True)
End If
Set doc = view.getnextdocument (doc)
Wend
End Sub
This was first published in November 2000