This is one article in the larger Troubleshooting SharePoint Alerts guide

Problem

You are unable to open the alert messages if :-

• You have a mailbox on a server that is running Microsoft Exchange Server 2003.
• You use Microsoft Office SharePoint Server 2007 to send a notification message to the mailbox.
• You try to open the SharePoint Server 2007 notification message in Microsoft Office Outlook 2007.
• Outlook 2007 is running in Cached Exchange Mode.

References

• KB 930807 – You cannot open a SharePoint 2007 notification message in Outlook 2007 when your mailbox is on Exchange 2003 Server

To Fix

• Apply hotfix  mentioned in KB930807

or

• Disable Cached Exchange Mode (be careful of the performance impact of doing this, see comments)

Fixed in

• Microsoft Exchange Server 2007

Related posts:

1. Troubleshooting – Task modified alerts getting sent to random, incorrect recipients This is one article in the larger Troubleshooting SharePoint...
2. Troubleshooting SharePoint Alerts – Upgrade from 2003 to 2010 Problem Consider the following scenario. You perform a database...
3. Troubleshooting SharePoint email alerts – Checking the Email Infrastructure This part of the alert troubleshooting guide will talk...
4. Troubleshooting – The date format in Alert emails is incorrect This is one article in the larger Troubleshooting SharePoint...
5. Troubleshooting SharePoint Alerts – Part 1 This guide will help you troubleshoot why you are...