Forum Discussion
ian91827
May 26, 2022Copper Contributor
Windows 11 Anomaly with VBA Mailmerge
hi We have Office365 desktop apps on all computers ,running latest version of Microsoft Access We have an internal system written on Microsoft Access which uses vba code and Microsoft Word Mail ...
George_Hepworth
May 26, 2022Silver Contributor
ian91827 After a quick search on error code 5922, I turned up this related discussion from a few years ago.
It sounds like there may be problems in the way the connection to Word is crafted. Perhaps start over with the suggestion contained in that link.
Also, make sure that all of the records in the recordset being sent to the Word mailmerge are acceptable to it. Given the fact that some records are sent out via mailmerge, but others aren't suggests some issue with the data. When it's an all-or-nothing problem, we look more to code or to environment. When it's a random problem like this, we look first to data.