Trap a 'Cancel' click from a Mail Merge dialog box

[jcc285]

I am opening a Mail Merge dialog with, DoCmd.RunCommand acCmdWordMailMerge. This is then fine as long as the user clicks 'OK'. i.e. picks a Word Document.



Can anyone tell me how to trap the possibility that the user clicks 'Cancel' or 'closes the dialog'

I want :

If ???????????? = Cancel or Close then
Do Something
End If

I don't know to address the pop up dialog

Any help gratefully received.

[June7]

Google: access acCmdWordMailMerge

Review http://access.mvps.org/access/RunCom...deex/2-195.htm

Darn! Just tested that error handler and not working. Seems the value of Err when the dialog is canceled is 0 not 2501.

Might be interested in this approach http://www.minnesotaithub.com/2015/1...ba-and-access/