Notes of my Lotus Notes Headline Animator

Search My Blog

Tuesday, August 2, 2016

Exporting/Logging e-mail details in some excel sheet from any Folder or Inbox

If you want all these details logged in some excel sheet

1.     Select the documents and go to File menu > select Export...

 2.     Select folder in which you want to save.
         Select Save as type as Comma separated value.
         Give some name, say, attachment_logs.csv.
         Then click on Export button.
 3.     It would bring another small dialogue box.
         If you want details of selected mails then select How Much to Export as 'Selected documents'.
         Otherwise you may select 'All documents'.
         Export Character Set keep as 'Default character set'.
         Check the Details to Incorporate as 'Include View titles'.
         Otherwise just with the data you may get confused.
         Especially if you are NOT a lotus notes developer, then you would get confused with the extra column values that get exported.

4.     Once the export is completed you would see the below message in the bottom pane of your mailbox.
        You may delete the extra columns that get populated in the .csv file and keep only those you need.

 The result would look somewhat like this:

Hope this helps!! :)

How to see how many attachments are there in each mail and what are the attachment names?

Follow the images and make changes in your Views > All Documents. Or you may make these changes in specific folders as well.
1.     Right-click in the folder/view where you have your mails (with or without attachments) and select Design Folder...

2.      Select the Who column as highlighted in the below snapshot.
And do right click - then select Insert New Column...

3.     A new blank column will be created.
        Double click on the column and below properties box will open.
        Give a name in the Title text box.
        Select Multi-value separator: as New Line.
        Then in the bottom pane it must be showing various options.
        Select Attachment Names.

4.     Similarly you can insert another new column in front of Attachment Names column and give a name, say Count.
        For this you set Multi-value separator as ‘None’ - which is the default option set.
        In the bottom pane you can select Attachments instead.
        This will give you number of attachments present in each mail.

5.     Ctrl+S to save the design changes of the folder/view.
        Then close the folder/view.
        Close your mailbox and re-open to see the changes.

The new design would look something like this:

Hope it helps!!