The only CLI for mail that I'm aware of is this:

http://en.wikipedia.org/wiki/MH_Message_Handling_System

Otherwise mutt is probably the best console mail client out there.