Runtime -2147023170 error on MailMerge

[kckay]

We utilize Excel worksheets in a workbook to help document site inspections. From these worksheets, a findings letter is produced. The VBA written is included in Excel as an Add-In.

My department has 20 machines ranging from desktops to laptops to Surface Pros 3/4 to HP Elite X2 tables. All machines are W10/Office 2013. All of the machines use the exact same Add-In containing my code.

I have 1 HP Elite X2 (out of 5) that will return

"Run-time error '-2147023170 (800706be)':
Automation error
The remote procedure call failed."

I do not get this failure from any other machine.

The code identifies as failing on the first line (by highlighting it):

    With appWD.ActiveDocument.MailMerge
        .OpenDataSource Name:=fname, SQLStatement:="SELECT * FROM
[listing]"
        .destination = wdSendToNewDocument
        .SuppressBlankLines = True
        .Execute Pause:=False
    End With

If I take the workbook to another machine and run the mailmerge code, it will generate the letter correctly and without fail.

Trust Center settings are the same between all 25 machines. So are the group policies and individual permissions.

It appears the problem is due to the installation of Office 2013, but trying to convince my IT department of that is interesting to say the least.

I am having the 'owner' of that machine double check the VBAProject references. He let me know they are set the same as all of the other machines.

What direction should I be looking? I am stumped.

Much appreciated.

 

[Macropod]

It appears the problem is due to the installation of Office 2013, but trying to convince my IT department of that is interesting to say the least.

A faulty Office installation is the most likely culprit. A repair of the Office installation (much easier than uninstalling & reinstalling) is the usual first remedial step.