This question already has an answer here:
I have multiple email accounts and the messages are either forwarded to one Gmail account or I get them via POP/IMAP. Now I want to simplify all that and use only one account and get rid of all others. I need to list all senders who wrote to each of my email addresses, so I can notify them about my new account or in case of websites, change my email address there.
I could search the emails like this:
and go through all emails. But unfortunately I have too many emails.
For the people out here who understand SQL, the query would be something like this:
select FromAddress from emailsTable where ToAddress = "myOldAddress@gmail.com" group by FromAddress
Another idea is to download all emails (Google allows you that) and scan them somehow. But I'm not sure though whether I can put it in an Excel or something.