Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
All that's giving me is the mail that's on my server (POP), not the full count of the inbox on my machine, which dates back to 2009.

In finder, click Go -> Folder. Then enter /Users/*user name here*/Library/Mail
That folder will contain your mailboxes.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.