How to create list of emails in given inbox

HCL Domino Domino Forum
1

I apologize in advance if this is the wrong forum. I am a user of Notes 8.5 with a simple question. Is it possible to create an inventory of the items in my mail inbox? I would like to simply export the “Who”, “Subject”, “Date”, etc of every email in a certain inbox to a flat file (.xls, .csv). Is there a simple way to do this?

Thank you in advance for your help.

Mark

2

Subject: Several ways to do this

Depending on your skills, you can do this several ways.

The easiest is to select the email you want to export, right-click and select “copy selected as table”. You then simply paste this into Excel.

This requires Notes 8.5, and also that all data you want to export is visible in the view.

Another way require you to write some code. You simply loop through the view and write the values you like to a CSV file. I write code like that all the time, it is nothing complicated at all.

I once wrote a class to export view content to CSV (and HTML), you can find it here: Export Notes view to Excel – with multi-value fields – TexasSwede

I would be trivial to modify it to export additional fields, by reading the NotesDocument instead of the NotesViewEntry.

3

Subject: Re: How to create list of emails in given inbox

Hello Mark!

You can export all data on view to a CSV File.

Here is the step by step copied from Lotus Notes Client Help:

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

How can I export view data in CSV files?

You can export IBM® Notes® view data to a CSV file. The Comma Separated Value (CSV) file format is a simple ASCII text file with one record per line, whose fields are separated by commas. The documents in the view will appear as individual records in the CSV file.

About this task

Only Notes view data is exported. You cannot export data to CSV format from an open document. Exporting from a view does not remove documents from the view, but simply copies the data into a new file.

CSV import is not supported.

Perform the following steps to export a Notes view in CSV format:

Procedure

  1. In a view, select the documents you want to export.

  2. Click File → Export.

  3. In the File name field, either create a new file by typing a name and extension, or replace data in an existing file with the exported data by selecting the file. Use .csv as the extension.

  4. Click Comma Separated Value in the Save as type field.

  5. Click All documents or Selected documents.

  6. To include the view titles in the exported file, check Include View titles.

  7. Specify the Export character set. The options are the default character set, International (UTF-8), and Unicode.

  8. Click OK.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Best Regards!