EmailDatabaseObject causes error when cancelled

[matt_wpg]

Hi guys, I have a macro run when a button is pressed to email a pdf of a form. This works great unless the user cancels the email, it will cause an error when the user tries to exit the database. The message says "You can't exit database X right now. If you're running a visual basic module that


is using OLE or DDE, you may need to interrupt the module."

Any ideas?

Thanks in advance!

[ranman256]

Did you put in an error trap?

cant you just use:
docmd.SendObject....

[matt_wpg]

Thanks for the reply @ranman256.

I tried using an error trap and now it is just freezing access completely.
To be honest, I don't know the differences between the different traps. I will do some research and post if I manage to solve the issue using an error trap.

[ranman256]

the 1st statement after the DIM variables is ON ERROR GOTO name
then the block after the label is where the code will go and stop when it hits the messagebox.

sub MyRoutine()
dim x,y

on error goto ErrStop
   'code
exit sub

ErrStop:
 msgbox err.description,,err
end sub

[matt_wpg]

Thanks @ranman256! Much appreciated!