Google Apps Sync for Microsoft Outlook will allow you to use Google Apps instead of Microsoft Exchange together with Outlook 2003 and Outlook 2007.

Check out the demo video:

And keep your eyes at http://google.com/apps/get-outlook-sync where it will be available for download soon.