leslieinva
asked on
Count the number of messages from senders in Thunderbird?
Is there any way to count the number of messages one has received from all senders in Thunderbird?
ASKER
ElrondCT,
Sorry I should have been a little more specific. I want to know how many are from each individual sender, not the total number of messages from all senders.
Sorry I should have been a little more specific. I want to know how many are from each individual sender, not the total number of messages from all senders.
You could create filters for each sender which moves the messages from that sender to a folder with his name. If you then go into that folder the number of mails contained in that folder are displayed at the bottom of the window.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, I did want the process to figure out who all the senders were rather than have me provide a list (there are just too many of them).
The ImportExport Tools works great!!! I can't figure out how to count the senders with the Excel subtotal features though, but I know how to do this with Access, so I'll use it.
The ImportExport Tools works great!!! I can't figure out how to count the senders with the Excel subtotal features though, but I know how to do this with Access, so I'll use it.
Ah, yes. You need to put a little more information in, because subtotaling requires column headers. Steps in Excel:
1) Open the .csv file in Excel (you'll need to choose files of type "Text Files (*.prn;*.txt;*.csv)").
2) If you used the ImportExportTools export choice of Just Index (.csv), then you'll have four columns: subject, sender, receiver, date & time. Click on a cell in column B (sender).
3) Insert a blank line for row 1 (right-click on the 1 row number, then choose Insert).
4) Add column titles on the first row, such as "Subject","Sender","receiv er", "date & time".
5) In Excel 2007/2010 (probably also 2013, but I don't have that), use the Home tab of the ribbon, and click on Sort & Filter. From the secondary menu, choose Sort A to Z.
6) Go to the Data tab of the ribbon. Click on Subtotal. Choose:
At each change in: Sender
Use function: Count
Add subtotal to: Receiver
7) Subtotals are created. To view just the subtotals, click on the 2 box at the top of the subtotals organization section to the left of the actual data.
8) If you want to copy just the subtotals, press <Alt>+; (i.e., hold down the Alt key and press semicolon) to select just the visible cells, then Copy and Paste like normal.
1) Open the .csv file in Excel (you'll need to choose files of type "Text Files (*.prn;*.txt;*.csv)").
2) If you used the ImportExportTools export choice of Just Index (.csv), then you'll have four columns: subject, sender, receiver, date & time. Click on a cell in column B (sender).
3) Insert a blank line for row 1 (right-click on the 1 row number, then choose Insert).
4) Add column titles on the first row, such as "Subject","Sender","receiv
5) In Excel 2007/2010 (probably also 2013, but I don't have that), use the Home tab of the ribbon, and click on Sort & Filter. From the secondary menu, choose Sort A to Z.
6) Go to the Data tab of the ribbon. Click on Subtotal. Choose:
At each change in: Sender
Use function: Count
Add subtotal to: Receiver
7) Subtotals are created. To view just the subtotals, click on the 2 box at the top of the subtotals organization section to the left of the actual data.
8) If you want to copy just the subtotals, press <Alt>+; (i.e., hold down the Alt key and press semicolon) to select just the visible cells, then Copy and Paste like normal.
ASKER
I see. That works. THANKS!!!!!!!!!
You could do a search for the entire account for all messages whose sender is not yourself. Menu selection Edit / Find / Search messages (or press Ctrl+Shift+F). In the match list, select From, contains, and enter your own email address in the white box. Click Search; when the report is complete, a number of matches is displayed.