ms access mailmerge
1 TopicWindows 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 merge templates and an ODBC 64 bit MS Access Data source to facilitate multiple mailmerge document creation The code is actually looping though doing about 20 mailmerge documents Only problem is it only works on Windows 10 computers ,it does not work on Windows 11 ??? ,(Office Configuration and ODBC is identical) it crashes after doing about 10 successful mailmerges. It gives the error message 5922 at this point in the code objDoc.MailMerge.OpenDataSource Name:=strDBPath, _ LinktoSource:=True, _ Connection:="DSN=workgroupname;", _ SQLStatement:="SELECT * FROM " & strQueryName .Destination = wdSendToNewDocument objWord.DisplayAlerts = wdAlertsNone the next line of code which it does get to is .Execute Any help at all on what this would be very gratefully received1.5KViews0likes1Comment