Fairly sure that Windows Live Mail does a single receive. It is what my wife uses having moved from OE on XP to Windows 7. She has more than one email account.
Combined view from all sources is ok but are grouped by email account. It is to the to not from that combines them. Thunderbird is the main alternative. As far as I am aware Opera is not similar.