• Skip to content
  • Skip to primary sidebar
  • Skip to footer

Foliovision

Making the web work for you

Main navigation

  • Weblog
    • FV Player
    • WordPress
    • Video of the Week
    • Case Studies
    • Business
  • About
    • Testimonials
    • Meet the Team
    • We Support
    • Careers
    • Contact
    • Pricing
  • Products
  • Support
    • FV Player Docs
    • Pro Support
  • Login
  • Basket is empty
Affordable VAST/VPAID for Wordpress has arrived. Serve ads with your videos starting today!

Ghost Apple Mail Messages: “Show in Mailbox”

3 January 2010 / Alec Kinnear / 3 Comments

I ended up with thousands of these ghost messages after moving from Eudora to Apple Mail with the help of Andreas Amann's brilliant Eudora Mailbox Cleaner. I didn't worry too much about it, as the messages were there in duplicate.

But after a while I got tired of seeing double messages when searching the old archives. I couldn't find any way to scare away these ghosts. Rebuilding the mailboxes didn't help. Nor did running duplicate message scanners.

Even the fantastic vacuum command line cleanup routine wouldn't get rid of the ghost messages with their "Show in Mailbox" in the top right corner. But vacuum did get speed up Apple Mail (highly recommended).

sqlite3 ~/Library/Mail/Envelope Index vacuum;

But finally I found the solution on a long dead Omni mailing list archive.

Here's how to stop the haunting. The issue is with the Envelope index. It needs to be deleted. Steps:

  1. Quit Apple Mail
  2. Open up ~/Library/Mail
  3. Delete Envelope Index
  4. Restart Apple Mail
  5. Sit back and wait as the full index is rebuilt

Don't do this if you are in a hurry. For my 270,000 messages, it takes about twenty minutes to index them all (pretty spiffy coding Apple Mail Team, getting through that many messages that quickly).

But when it's done, your messages will all still be in place, but your index will be a whole lot faster. I don't know why vacuum only partially cleans and why Apple Mail doesn't have an effective built-in cleaning mechanism. But I'm happy that all systems are go again. Now that you know this trick to, you won't have to care either.

As a footnote, I should say that I was initially a reluctant switcher from the poor departed Eudora (the most robust and configurable email client ever). But Apple Mail handles my huge database of messages astonishingly well and looks quite a bit better doing it.

Alec Kinnear

Alec Kinnear

Alec has been helping businesses succeed online since 2000. Alec is an SEM expert with a background in advertising, as a former Head of Television for Grey Moscow and Senior Television Producer for Bates, Saatchi and Saatchi Russia.

Share
Tweet
Share
0 Shares

Categories: IT

Related Posts

  1. Apple Mail IMAP: Sent Mail Showing up in wrong folder on second computer

    Apple Mail IMAP: Sent Mail Showing up in wrong folder on second computer

  2. Apple Mail: Fixing Broken IMAP accounts after a server move

    Apple Mail: Fixing Broken IMAP accounts after a server move

  3. Apple Mail: Getting rid of multiple draft messages in IMAP

    Apple Mail: Getting rid of multiple draft messages in IMAP

Reader Interactions

Comments

  1. Stuart Haiz 17 August 2010 at 3:54 am

    Thanks Alec – this fixed the same problem I was having, and helped me retrieve an important message!

    (I’ve linked to this post from my blog: haizdesign.com/blog/mac-osx/show-in-mailbox/ )

    Reply
  2. alec 17 August 2010 at 7:24 pm

    Glad it helped you Stuart! The “Show in Mailbox” issue drove me batty for about six months before I figured out the cure.

    Reply
  3. Brian 19 October 2011 at 7:02 pm

    Thank you very much, just had that happen to me and its fixed now. Thanks a ton. it was very annoying

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

You can click here to Subscribe without commenting

Primary Sidebar

Categories

  • Business
  • Cameras
  • Case Studies
  • Design
  • Flowplayer
  • Internet Marketing
  • IT
  • Life
  • SEO
  • Slovak
  • Video of the Week
  • WordPress

Footer

Our Plugins

  • FV WordPress Flowplayer
  • FV Thoughtful Comments
  • FV Simpler SEO
  • FV Antispam
  • FV Gravatar Cache
  • FV Testimonials

Free Tools

  • Pandoc Online
  • Article spinner
  • WordPress Password Finder
  • Delete LinkedIn Account
  • Responsive Design Calculator
Foliovision logo
All materials © 2021 Foliovision s.r.o. | Panská 12 - 81101 Bratislava - Slovakia | info@foliovision.com
  • This Site Uses Cookies
  • Privacy Policy
  • Terms of Service
  • Site Map
  • Contact
  • Tel. +1 518 412 4600