How to check if email was sent when macro run.

[behnam]

Hi all,

I have a macro called SendMail which is a simple access macro using the EmailDatabaseObject (defined in access already). when the user runs it, it emails a pdf but dosent send it auomatically, the outlook screen pops up and the user then presses sent. Is there a way to check it sent was pressed or if the user closes the email screen without sending. Because if its not sent i dont want to run the rest of the code. Thanks.

[June7]

If it's not sent will generate error message. Perhaps use error handler code to capture that error number and terminate code execution.

[behnam]

thanks June7