DoCmd.SendObject acSendReport



On Error Resume Next
DoCmd.SendObject acSendReport, "STATS", acFormatRTF,
"(e-mail address removed)", , , "Please Find Stats"

Send obj creates an email with a report attached - fine - i can send it -
If I dont 'send' the email (whilst i'm testing, and it is going to happen)
and cancel it - Access generates error "you've quit a VB Process by closing
the object...." & hangs up - I have to kill the whole application

Included On Error command to no avail

Any clues?


Works fine now I have changed the for from popup to normal - it was behaving
like 'modal' form albeit it wasn't modal

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question