I have some email rules that run vba scripts when email arrives. they all throw errors about "an unexpected error has occurred" since i upgraded from patch Version 2108 (build 14326.21018) to the latest patch version 2202(build 14931.20604). about my setups: im running Microsoft 365 apps for enterprise on a machine running Windows 10 Enterprise 21H2. all the rules move the emails to different outlook folders based on subjects/senders, this part is still working whether the script is working or not. in addition, some of the rules dont run scripts and they still work fine. some of the rules run scripts and they are broken. those rules only break when email arrives automatically and work fine if i run them manually on the existing email items in the inbox. the vba scripts are very simple and save email attachments to the network drive. given they have been running fine for 5 years and work when running manually, i assume i have done Outlook/registry security/macro settings correctly, e.g. allow all macros in outlook, turn on EnableUnsafeClientMailRules in registry, etc. things I have tried but didnt fix the issue: unable/disable Cached Exchange Mode re-create OST/NST/SRS files export/import all the rules re-create all the rules re-install office and upgrade to latest v2202. things I have tried that did fix the issue: re-install office and stay at an earlier version. whenever i upgrade, they break again. restore my machine to the state on early July. whenever I upgrade, they break again. anyone have any thoughts about this issue? I have searched online for a while and exhausted all the options.

email rules with scripts break in version 2202(build 14931.20604)

leolegend 1

I have some email rules that run vba scripts when email arrives. they all throw errors about "an unexpected error has occurred" since i upgraded from patch Version 2108 (build 14326.21018) to the latest patch version 2202(build 14931.20604).

about my setups:

im running Microsoft 365 apps for enterprise on a machine running Windows 10 Enterprise 21H2.
all the rules move the emails to different outlook folders based on subjects/senders, this part is still working whether the script is working or not.
in addition, some of the rules dont run scripts and they still work fine. some of the rules run scripts and they are broken.
those rules only break when email arrives automatically and work fine if i run them manually on the existing email items in the inbox.
the vba scripts are very simple and save email attachments to the network drive. given they have been running fine for 5 years and work when running manually, i assume i have done Outlook/registry security/macro settings correctly, e.g. allow all macros in outlook, turn on EnableUnsafeClientMailRules in registry, etc.

things I have tried but didnt fix the issue:

unable/disable Cached Exchange Mode
re-create OST/NST/SRS files
export/import all the rules
re-create all the rules
re-install office and upgrade to latest v2202.

things I have tried that did fix the issue:

re-install office and stay at an earlier version. whenever i upgrade, they break again.
restore my machine to the state on early July. whenever I upgrade, they break again.

anyone have any thoughts about this issue? I have searched online for a while and exhausted all the options.

Faery Fu-MSFT 18,741 Reputation points Microsoft Vendor

2022-07-29T07:09:38.693+00:00

Hi @leolegend ,

Please kindly understand the tag” office-outlook-itpro” which mainly focus on general issues about Outlook desktop client. According to your description, seems that issue is more related to VBA. In order to better resolve your problem, I will add the tag” office-vba-dev”, so that users of their forum can help to see it together.

Thanks for your understanding and hope your issue would be resolved soon.
leolegend 1 Reputation point

2022-07-29T15:31:00.87+00:00

thanks! our IT department suggested the same that, its possible that some of the VBA/scripts syntax/format upgraded so my scripts may not work under the new patch. however, i wasnt able to find anything related to this in the patch notes. also, given the rules/scripts work fine on existing items, its very hard for me to debug the scripts.
Markatatos Manolis 1 Reputation point

2022-09-15T13:55:18.283+00:00

Hi! Have you found the solution or a workaround. I am asking as I face the same issue
leolegend 1 Reputation point

2022-09-28T16:17:41.62+00:00

unfortunately, I have not found a solution to this and im still using the older version of Outlook.

Share via

email rules with scripts break in version 2202(build 14931.20604)

Your answer