SendObject more than once??

[Jim K]

I have a macro that uses the SendObject command to e-mail
a report. I access it from a button on my switchboard.
The problem I have is that it runs fine the first time I
use it after opening the database, but when I try to run
it a second time the macro fails. If I close and reopen
the database, it's good for one more run and then fails
again. Any idea on how to fix this? Thanks for
suggestions/help.

 

[Jim/Chris]

I used to have that problem. That is a bug in Access
2000. Make sure you have all the service patches
installed. Also instead sending using a macro use vb
code. It seems to be more stable.

Jim