I'm posting this workaround for the SendObject bug in Access 2000 for anyone interested. This works in a macro. I have not tested it with VBA, but it could be adapted to use in a module. I've been using this workaround for several months in a number of different databases, and it has completely eliminated problems with sending several reports in succession and sending large reports:
1. Use a form to prompt the user for the Email address
2. Use the OpenReport macro action to open the report before sending it.
3. In the arguments of the SendObject action, keep the message length to as few characters as possible (less than 70 according to Microsoft