Unread message count is wrong in Mail and Dock

FWIW, the same fix works in Snow Leopard, but the files are in user/Library/Mail/ (no V2, etc.). Thanks for the fix!

Good work Hackintosh, thanks! This was driving me insane!

Cheers Glenn, good work!

This happened to me too, but in Mountain Lion. Same file location as in Lion and there were three "envelope Index" prefixed files. I have 1 iCloud, 3 Exchange and 1 Gmail accounts, if that matters. Deleted all three and the indexing took about 10 minutes for 31,000 messages but it worked. Even found a few more errors of items that weren'y actually read.

41,000 emails reindexed, correct unread counts in inboxes! Thanks!

Please help, I have two mailbox accounts but only one of them is showing the new inbox count and makes "the noise".

I've tried everything, I've swapped accounts around, reinstalled them and also did the envelope index thing but nothing worked.

I am running version 10.7.4

Thank you

When I tried this, nothing happened in Outlook but when I restarted Apple Mail it started to reimport old mail (or at least that what i think it said). I am running 10.7.4, I have Outlook and Mail running against different accounts (Outlook for work) (Mail for personal)

Can somebody offer a little more help to me as a beginner please

Thanks😕

I had the problem in Mountain Lion as well, and deleting the Envelope files didn't appear to fix the problem — tried twice, still had the errant unread email in my inbox. What ended up clearing out that unread email: I simply disabled the account and reenabled, and poof.

Wow, I spoke too soon. The unread count goes to 0 when I reenable the account, but jumps back up to 1 incorrectly if I restart Mail or poke around in other folders. What the what!

Sorry, I'm a bit slow as far as understanding Glenn's and Hackintosh's instructions. I got as far as closing Outlook. Where do I go next?

Thanks.

Note that those suggestions are for Apple Mail only. I'm not sure where Outlook stores it's indexing files. You should post a new discussion if you are having problems with Outlook.

It's done it again, following the latest update. Deleting the envelope files from the library did not work. Any ideas?

UPDATE: I rebuilt the library 3 times and rebooted twice before it finally took.

It worked. The rebuilding took a while -- it's like installing MAIL from scratch -- the absence of the folders makes MAIL import all the mailboxes it finds and this reconstruction for me was about 65K messages and took about 9 minutes. The inboxes (I have 7 email accounts) seem to be intact although there was a brief panic when the Exchange served account looked empty -- closing and reopening MAIL a couple of times seemed to fix things.

The solution is brute force, but it works. The underlying database was corrupted in some way that let MAIL work with it but without a correct count. The fix is to force the database manager to recreate the database from scratch. This is a recurring problem with databases and it is disturbing to me that it occurs with a critical application like MAIL. Software quality remains the Achilles heel of modern computing.

Thanks for the solution... now back to work for Dr. Bunsen Honeydew!

--beaker

Thanks to Glenn Leblanc for his posts. I had actually spoken to Apple about an issue where blank emails were landing (in work exchange server) and bumping up my unread badge count — permanently. Very frustrating and Apple engineers (after a couple of hours on seperate phone calls) couldn't resolve it! Deleting them made no difference and because the badge count was ever-changing, I eventually switched it off! (in Settings / Notifications). Then I came here last night and bingo! All good again.

For the record — in Mountain Lion — I had to quit Mail. Then hold alt/option key in Finder's 'Go' menu to find Library: then Library/Mail/V2/MailData. Found files: Envelope Index-wal, Envelope Index-shm and Envelope Index and moved them to the Desktop.

When you restart Mail it begins reindexing all your Mail accounts. This should be all it takes to get a correct badge count. It took 15-20 mins for app. 45,000 mails.

When it's all done you can delete the Envelope Index-wal, Envelope Index-shm and Envelope Index files on your desktop — they will have been replaced in Library/Mail/V2/MailData anyway.

Hope this helps Mountain Lion users and, seriously, massive thanks to Glenn for solving this! 🙂

Edit. After restarting Mail for the first time things may still be a bit muddled. Don't panic. Disabling then re-enabling the account will clear that up.