i dont think you can use email clients to download msn and yahoo emails without its paid service or 3rd party software such as YahooPOPS. With GMail, you need to activate the Pop service by following Help Instructions.
If you do have these, first choose Tools->Preferences and select Advanced->Programs and set Opera to be your email client... Then follow step 1 of Warrior's post.
Arun