This redbook was written for Visual Basic programmers who want to learn about the NotesDocumentCollection, NotesACL, or NotesAgent from that database Currently I have an Excel VBA application that will retrieve all documents from a Dim LNdocs As NotesDocumentCollection. Dim LNdoc AsHi, I looking for a way to return all Notes emails created in the last 8 days in VBA Excel. Tried the code Search method returns NotesDocumentCollection: Object 'NotesDatabase Dim NDocs As Object 'NotesDocumentCollection Dim NDoc Is there a way to convert from simple text to rich text ? This LotusScript code shows how to sort a Lotus Notes document collection in Tutorial: 30 LotusScript tips · LotusScript Learning Guide · LotusScript 11 Jun 2015 Additional remarks: To get the mailfile that is configured in the client you do not need to hardcode the path, you can use three simple lines to get I need an excel macro to get different data from lotus notes text body and . 'NotesDatabase Dim NDocs As Object 'NotesDocumentCollection I have the task of retrieving data from a Lotus database using VBA. Dim doccol As NotesDocumentCollection aware that Notes databases are not relational: they're databases in the same sense that Excel has "databases". 18 May 2015 My Excel VBA macro currently reads through all documents in a database using "View.GetNextDocument(doc)" and testing the contents to I have 100 lotus notes document in the excel sheet. i have also got the notes url feild. but i want Dim dc As NotesDocumentCollection. Dim Doc As