Access/Outlook Error: Object not found

[Tim Brown]

Hi,

I have an Access database (Access 2003) that sends email
via CDO to Outlook 2003. Both are running on a Win 2003
Server.

The problem I'm getting - and can find nothing for on
the MS site - is that when Access tries to send the email,
Outlook first provides an error message: "The object could
not be found.", then Access returns Error -2147221233,
Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]

Now for the interesting bit (part 1): We have two 2003
Servers, which were set up in precisely the same way. On
one of the servers, the Access database can send the email
without any problem at all. On the other server, we get
the error.

Interesting bit (part 2): Although the error occurs, the
email message is still generated and placed in the Outbox
in Outlook. It is then possible to go in and send the
messages as normal.

Has anyone any ideas/thoughts/etc as to why this error is
occurring? I can't find anything about it in the
Knowledge Base.

Thanks,
Tim

 

[Guest]

OK I designed a call logging database that can send a single report to an Outlook user.
I had a lot of trouble with Access not knowing what I was sending and snedinbg empty reports instead
To get around the problem I do this. The form that has the report or data I wish to send also has a reference number
I use an activation button to start a Macro that closes the form and starts a SendObject /Report in Snapshot. The report in turn runs from a query that requests the reference number. An outlook 'send' dialog appears for you to add the end user
What they receive is a snapshot view of the data (They need MS Snapshot Viewer installed)
Hope this helps