We have an Access 2000 database that sends emails with a report attached to each, from several buttons using DoCmd.Sendobject acReport, etc.... The send fails after the first one is sent, but no error message occurs. If we close the database and go back in, we can send another one, but it never will send more than one without failing on subsequent sends. The send function works fine in our 97 version of the database. Has anyone encountered this, and do you know if it is a known bug and how to resolve it? Thanks.
Failing Sendobject
- Thread starter mikemaki
- Start date
I've had the same problem using the sendobject command twice consecutively. I thought it may be due to the Vv "tripping over" itself so i added a short pause in the code between commands and that helped. If that doesn't fix the problem completely if you're using Outlook you can create a mail object and send that rather than use the sendobject command.
Tom.
Tom.
- Local time
- Today, 06:36
- Joined
- Aug 30, 2003
- Messages
- 36,270
It appears I forgot the link I had found - sorry!
http://support.microsoft.com/default.aspx?scid=kb;en-us;260819&Product=acc2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;260819&Product=acc2000
