Access SendObject Macro Error
I have created a Macro using SendObject (and nothing else) to email a report. The Macro runs correctly & the email is sent with the correct attachment. The problem is that after the macro has finished & I open another object (or if the switchboard is already open) an Error occurs & Access closes. "Microsoft Access has encountered a problem & needs to close". An error Report is generated to send to Microsoft but this doesn't mean anything to me.
I haven?t used any VBA in the database.
I am using Access 2002.
I have done a Compact & Repair, but this hasn't helped.
Any suggestions would be greatly appreciated.
Thanks
Charlie