Share via

Easiest way to find largest emails in Outlook app.

Anonymous
2024-01-15T16:53:40+00:00

Hello everyone,
For work requirements I would need to extrapolate via Powershell or BAT the size of mail attachments for each of our users.
We use the Office suite as the program installed on the PC to which we apply the last year mail retention rule.
Looking online I find only total mailbox sizing or similar, I found however only this guide : https://support.microsoft.com/en-us/office/find-all-messages-with-attachments-b1395e66-804f-4d05-99ef-0fbd9618fecf which allows me to do what I am looking for but as anticipated before only on the last year of mail.
I certainly can't download every year so as not to fill up the PC disk and definitely an operation I can't do on more than 150 users.
Thank you all for the support!

Outlook | Windows | Classic Outlook for Windows | For home

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-01-20T18:31:35+00:00

    I have the same issue. Once I get to step 3 of your instructions

    . Click on "View Settings" and then "Columns"

    I click on view setting but columns is not available please can you advise and show screenshots

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2024-07-30T12:17:06+00:00

    Hello all,
    Found a PS1 that does the job.
    Visit here : https://lazyadmin.nl/powershell/office-365-mailbox-size-report/

    Thanks all for the support!

    0 comments
  3. Anonymous
    2024-07-29T14:21:09+00:00

    Agree! I also cannot follow the instructions given as per your comments!!

    0 comments
  4. Anonymous
    2024-04-08T04:28:28+00:00

    I see no "Advanced View Settings",

    Or columns under "View Settings"

    under Help and search, columns doesn't show up.

    I have Microsoft Outlook Version 1.2024.327.300 (Production).

    Do I need a newer version?

    Thanks

    0 comments
  5. Anonymous
    2024-01-15T18:47:07+00:00

    Dear Emir Guetari

    Good day! Thank you for posting in the Microsoft Community. We'll be happy to help!

    First of all, we apologize for the inconvenience and inconvenience caused to your work. Based on your description, you can easily find the largest emails by sorting your mailbox by size. Here's how:

    1. Open Outlook and go to the folder you want to search (e.g. Inbox, Sent Items, etc.).
    2. Click on the "View" tab in the ribbon.
    3. Click on "View Settings" and then "Columns".
    4. In the "Select available columns from" dropdown, choose "Size".
    5. Click "Add" and then "OK".
    6. Your mailbox will now display a "Size" column.
    7. Click on the "Size" column header to sort your mailbox by size, with the largest emails at the top.

    .

    You can check out the screenshot of my test above, so that all emails will show their size and will be automatically arranged in descending order.

    Thank you in advance for your understanding. Your patience and cooperation will be greatly appreciated. I hope for all the best!

    Sincerely

    Kerry Chen | Microsoft Community Moderator

    0 comments