SendObject more than once??

  • Thread starter Thread starter Jim K
  • Start date Start date
J

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.
 
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
 
Back
Top