Windows 10 will reach EOS (end of support) on October 14, 2025. For more information, see this article.

Search Support

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

Extracting only junk emails address to Excel

  • 2 replies
  • 0 have this problem
  • 3 views
  • Last reply by sfhowes

more options

How can I extract a list of only junk email addresses so I can block the in the upstream provider. Tired of copy and edit to update locked list. Far too many spammers.

How can I extract a list of only junk email addresses so I can block the in the upstream provider. Tired of copy and edit to update locked list. Far too many spammers.

All Replies (2)

more options

To my knowledge, no such tool exists - BUT, there is a way to ease the pain. If you open the junk file with a text editor such as Notepad, you can search for From: and that should stop at first line of a From address that can be copied. Pressing F3 to repeat the search will step you to next email. Continue that and you'll get through more quickly than reading each message. If put into a spreadsheet, a pivot table should find the duplicates.

more options

There are a couple of add-ons for collecting addresses in a csv file or address book (which can be exported to csv). But you might find that filtering on junk mail addresses is insufficient to block them.

https://addons.thunderbird.net/en-us/thunderbird/addon/mail-extractor/

https://addons.thunderbird.net/en-us/thunderbird/addon/collectaddresses/