Hi,I am new to this forum and I hope I a putting this in the correct place.
I have successfully wrote a script to send and email attachment to multiple recipients through excel vba.
I have change some of my code and when the excel file opens it now comes up with a dialog box asking to input my lotus notes password. Once I enter my password everything works as it should.
My problem is when the user presses the cancel button. Upon pressing the cancel button a dialog box pops up with the options to end or debug. How can I trap this error: -2147217504 and ask the client if they wish to exit, then quit the app, or try again and retry password entry.
Thanks Roland