Sorry for posting this in an old thread - it came up via Google.
I spent 2 days troubleshooting the same MS Access SendObject issue. Our email client is Lotus Notes. The solution was that my win.ini file was somehow messed up (in C:\WINNT or C:\Windows).
This code was missing...
[Mail]
MAPI=1...