Lotus whichfolders

Is it possible export whichfolders from Lotus to excel? I created a view, with column "folder", with function whichfolders. Improve this question. Hugo Suspiro Hugo Suspiro 3 2 2 bronze badges. Add a comment. Active Oldest Votes. I would try, however, wrapping the formula in a call to Text, just to see if that helps.

Improve this answer. Ken Pespisa Ken Pespisa If it doesn't help, try to use hat LotusScript method in exporting code. Frantisek Kossuth Frantisek Kossuth 3, 2 2 gold badges 22 22 silver badges 40 40 bronze badges. You also have to change NotesDatabase. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. How to determine folder where a message is? Reply to author. Report message as abuse.

Show original message. Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message. I'm using Lotus Notes 7. I can't find a way to add such a column, or any other way of finding out which folder a message is in even one message at a time. Anyone know? Andy Mic. I remembered that I'd worked on this problem before, and on another similar issue that was solved in a similar way.

In Notes, a folder is implemented as a view, with the only difference being that a view has a selection formula that describes which documents should be in the view. A folder doesn't. From the point of view of a document, these two are quite different. It's easy to see if a document is in a view or not by executing the view selection formula against the document. A folder works by maintaining a list of documents that it contains. Documents themselves don't know which folders they are in.

This starts to cause a problem when you start playing about with database designs, particularly if you delete and recreate the Inbox folder in a mail database.

If you delete the inbox folder, the list of documents that is in that folder vanishes with the folder.