Untill last week, I was using the "email" app on the phone because my main email address isn't gmail. But that app uses "pull" email which really drains the battery. Anyway, with a little help from google I found this info:
http://www.androidcentral.com/using-gmail-your-own-personal-push-mail-server.
They start off giving a basic over view of the difference between push and pull (great for a newbie like me) and then take you through a step by step process to use your gmail account to "push" your email from any account to your phone.
Anyway, since I've switched, I've seen a dramatic increase in my battery life, so I'm sure you will too.
All you need is a gmail account (which is a must anyway with an android phone!). Also, make sure to google your email providors "pop server" and "port" information. Its easier that trying to find it on yahoo.com or whatever you use.
Once you set up the gmail account to retreive email from your main account, you can set up the notifications on the app anyway you'd like. Personally I dont want my phone to viberate every time I get an email, but for those of you coming over from blackberry, I'm sure you'd want this. Hope this helps!