how to search and save subject line in thunderbird
i need to search mails and export the subject lines to excel.
সমাধান চয়ন করুন
After a closer look, it appears there are some bugs in the add-on: right-clicking a selection of messages, then 'Save selected messages/just index (CSV)' does not create a csv file, and choosing just index (HTML) produces an empty index.html file. Selecting 'Spreadsheet(CSV)' does produce a csv file, but it contains the message bodies.
However, if you right-click a folder, then ImportExportTools/Export all messages in the folder/just index (CSV), a csv file is created with columns for the Sender, Subject, Recipient and Date.
So, until the bugs are fixed, it looks like you will have to copy the search results to a folder for the purpose of creating the correct csv file; open it in Excel and delete the unwanted columns.
প্রেক্ষাপটে এই উত্তরটি পড়ুন। 👍 0All Replies (3)
If you search with Global Search (Ctrl-K), click on 'Open email as list' after you apply Filters, and the search results will open in a new tab. Next, select the messages you wish to export, then right-click and select 'Save selected messages/just index (CSV)'.
Use the same procedure if you search from the Quick Filter bar (Ctrl-Shift-K). The csv file will include Sender, Subject, Date etc. and can be opened in Excel.
Of course, before you do this it's necessary to install the ImportExportTools add-on (how to install).
Hi sfhowes ... Thanks...
This make the whole message in one column. I need only the SUBJECT LINE from the search list in excel. not the message body.
চয়ন করা সমাধান
After a closer look, it appears there are some bugs in the add-on: right-clicking a selection of messages, then 'Save selected messages/just index (CSV)' does not create a csv file, and choosing just index (HTML) produces an empty index.html file. Selecting 'Spreadsheet(CSV)' does produce a csv file, but it contains the message bodies.
However, if you right-click a folder, then ImportExportTools/Export all messages in the folder/just index (CSV), a csv file is created with columns for the Sender, Subject, Recipient and Date.
So, until the bugs are fixed, it looks like you will have to copy the search results to a folder for the purpose of creating the correct csv file; open it in Excel and delete the unwanted columns.