MS Outlook - Catching overwrite failures (or all errors) when using "SaveAsFile"

[UKRyan]

Hi,

I have a simple macro in Outlook (attached to the Quick Access Toolbar) that saves an attachment (one I regularly receive) to a specific location. This works fine and (helpfully) the SaveAsFile method overwrites the file even if it exists.

But what it does not do is warn if it can't overwrite the file (for example, when it is already open).

I was wondering how to capture errors (this one and any others in general)?

Thanks in advance.

Ryan

[natefarm]

You didn't attach your code for us to check, but I would assume there is an "Application.DisplayAlerts = False" prior to your SaveAs. This causes the app to take the default value, in this case, "Yes", when the overwrite prompt pops up. There is likely also an On Error command that tells the code what to do if an error occurs, and it probably says "On Error Resume Next", which just ignores the error. If that was changed to an On Error Go To directive, you could there check the Err.Number and respond accordingly. Look into the On Error command and the Err object for more info.

[UKRyan]

You didn't attach your code for us to check, but I would assume there is an "Application.DisplayAlerts = False" prior to your SaveAs. This causes the app to take the default value, in this case, "Yes", when the overwrite prompt pops up. There is likely also an On Error command that tells the code what to do if an error occurs, and it probably says "On Error Resume Next", which just ignores the error. If that was changed to an On Error Go To directive, you could there check the Err.Number and respond accordingly. Look into the On Error command and the Err object for more info.

Unfortunately, I couldn't get Application.DisplayAlerts to work with Outlook (I think it might not be available for it?). But On Error worked fine. I had tried that previously, but not sure why it didn't work and I didn't keep a copy of that code to check why. Never mind.

Thank you!!