সহায়তা খুঁজুন

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

how to search and save subject line in thunderbird

  • 3 উত্তরসমূহ
  • 3 এই সমস্যাটি আছে
  • 170 দেখুন
  • শেষ জবাব দ্বারা sfhowes

more options

i need to search mails and export the subject lines to excel.

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.

প্রেক্ষাপটে এই উত্তরটি পড়ুন। 👍 0

All Replies (3)

more options

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).

more options

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.

more options

চয়ন করা সমাধান

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.