Find Big Emails on Gmail

Roman messaged me yesterday about a problem one of his friend's was experiencing. His friend's Gmail account was more or less at the storage size limit which meant that the friend either needed to buy additional storage from Gmail, or delete emails.
Deleting the largest emails in the inbox should free up some space. But that is easier said than done considering that Google Mail has no option to sort emails by size, or to display the biggest emails.
Update: it is no longer necessary to use a third-party service for that. Gmail users can run commands in the search to filter emails by size. Other parameters are also available, for instance to only display emails with file attachments.
Roman pointed out that he discovered Find Big Email, a free service that creates a storage report for all Gmail emails.
The service updates statistics during the scan, and an email at the end of the scan lists the top 20 biggest emails in Gmail, as well as emails that are larger than 2 Megabytes, 500 Kilobytes and 100 Kilobytes.
Find Big Email creates labels in the Gmail account that list those matching emails directly. This makes it easy as pie to delete large emails that are no longer needed. It cannot get much easier to find big emails in Gmail. The service revokes all access permissions after the scan has completed, which means that you do not have to manually do that.
The biggest concern that many users may have is that you need to authorize the service to access your Gmail account. While you do not have to enter your password to do that, it still means that the third party service can access all of your emails. If you have trade secrets in your account, other valuable or personal information, or have important accounts linked to your Gmail account, you may prefer a different solution.
One solution is to use an external email program to download all Gmail emails to a local computer to find out which emails use up the biggest amount of space on Google Mail. I recommend Thunderbird for the job but you can basically use any desktop email program, Microsoft Outlook is fine as well for instance.
Thunderbird is available for Windows, Linux and Mac. It is not as easy to use as it requires some initial configuration on your side to link the Gmail account to the desktop email client. Once that is setup though it is more or less automatic.
The account creation screen will be displayed right after installation. You need to enter the account name, email address and password. Thunderbird will handle the rest and look up the Google Mail server information automatically. Make sure you keep the IMAP mail protocol setting and do not switch to POP3.
You still need to make one configuration change though if you want that your deleted emails in Thunderbird are automatically removed from Gmail as well. Click on Tools > Account Settings.
Locate your Gmail account in the listing and select Server Settings. Now switch from When I delete a message > Move it to this folder to Remove it immediately.
The final change is to enable the size column in the email listing. Click the last icon in the email header listing of the Gmail inbox and enable the Size column.
The column displays the size of every email in that folder, including its attachment size. You can now sort by size by clicking on the Size column in the header.
Deleting messages in Thunderbird will now automatically delete those messages in Gmail as well.
While it takes longer to identify big emails in Gmail this way, it is the safer way of doing it as no one but you gets to access all the emails of the account.
Bonus tip for the impatient. You can display all emails with attachments in Gmail by searching for has:attachment. While you still cannot sort those emails by size, it is usually fair to assume that the emails with attachments take up more space than emails without. Good for some quick cleaning, especially if you can identify messages that you do not longer need to keep.
A third option that you may want to explore is to use an email backup program like Mailstore Home which you can use to backup all Gmail emails.

You said that Outlook isn’t your main email client, so which is your main one?
I think its thunderbird
It is Mozilla Thunderbird.
Awesome! This actually solved my problem… what a stupid bug.
If this is the same bug that I’ve encountered, there may be another fix: (1) hover over open Outlook item in Taskbar, cursor up to hover over Outlook window item, and right-click; (2) this should give you Restore / Move / Size / Minimize / Maximize — choose Move or Size; (3) use your cursor keys, going arbitrarily N/S/E/W, to try to move or size the Outlook window back into view. Basically, the app behaves as though it were open in a 0x0 window, or at a location that’s offscreen, and this will frequently work to resize and/or move the window. Don’t forget to close while resized/moved, so that Outlook remembers the size/position for next time.
THANK YOU Claude!!! I could get the main window to launch but could not get any other message window to show on the desktop. You are my hero!!!!
Solved my issue! 6 years later and this is still problem…
Fantastic. Thank you. Size did the trick.
This solved my Outlook problem, too. Thank you. :)
Thank you so much, this started happening to me today and was causing big problems. You are a life saver, I hope I can help you in some way some day.
You are a god – thank you!
thanks a lot…. work like charm.. :-)
Yah…thanks Claude. I’ve been having the same problem and tried all the suggestions…your solution was the answer. It had resized itself to a 0/0 box. Cheers
Excellent post. This had me baffled even trying to accurately describe the problem. This fixed it for me.
Thank you
Thanks a lot for the article. Don’t know why it happenend, don’t know how it got fixed, but it was really annoying and now it works :-)
Thanks a lot. I was facing this issue from past 3 week. I tried everything but no resolution. The issue was happening intermittently and mainly when I was changing the display of screen ( as i use 2 monitors). The only option i had was to do system restore. But thanks to you.
I’ve been tried to sole this problem for 12hours. Your comment about changing the display of screen helped me a lot!! Thanks!!
Thank you…don’t know why this happened but your instructions helped me fix it. Running Windows 10 and office pro 2007
Great tip! Thanks!
Worked for me, too – thank you!!!
It’s Worked for me, too
thank you very much!
I had a similar issue with Outlook 2013 on Windows 10 and this helped me to fix it. Thank you very much!
Thank you so much. Solved!
Considering you published this in 2012, incredible not been debugged by Microsoft.
Thank you again. M
This problem was faced by only one user logging to TS 2008 r2 using outlook 2010.The issue was resolved.
Thanks.
Great tip. Thank you!!!! If it helps, I had to use the Control Key and the arrow keys at the same time to bring my window back into view. Worked like a charm.
Thank you, this worked !!!!
Man, you are a fucking god. Thanks a lot, what an annoying bug!!
Awesome, this post solved the issue. Many thanks!