Does SQL Remote MAPI work with Microsoft Remote Mail?
Yes. It is important to realize the limitations of this approach. Microsoft Remote Mail (MS Remote) provides a mechanism for exchanging messages between you local mail file and your Mail Server. MAPI reads and writes messages to the local mail file not directly with the Mail Server. This can cause some interesting behaviour. The most noticeable is that MS Remote will only download 50 messages per login to the server. If you have 51 DBRemote messages waiting it will take two connections to the server to retrieve all of your messages. These two connections are not done automatically. Instead you would get the first 50 messages from one DBRemote run. You would not get the 51st message until the subsequent run. This can make the transmission of large transactions impossible.