| Product | All |
| Version | All |
| Ticket | N/A |
| KB Permissions | Public |
Problem
After the Microsoft Word version 2211 update, attempting to print from the Staff Client triggers the following error message:
"The OpenDataSource method or property is not available because a macro is currently running."
We’ve reported this issue to Microsoft. You can read more about the issue here.
Status
An updated version of the Ares Client (v5.0.8) is now available that introduces a new mail merge method resolving this issue. Please run the v5.0.8 update for your Ares Client to implement this fix.
If you are unable to run the Client update, please click below for information on the manual workaround options available.
Video Overview
The following video provides an overview of the issue and the known workarounds prior to the Client hotfix release:
Option 1: Rollback the Word Update
Contact your IT staff to rollback to Microsoft Word Version 2209 or prior to restore automatic merging and printing. Disable Microsoft Word updates pending resolution of this issue. Instructions for this process are available in Microsoft's documentation.
Option 2: Manually Merge the Print Documents
Manually open the print template and merge it with the data source to create the merged print document each time you need to print from the Staff Client. Steps for manually opening the document and merging:
- Attempt to print your document(s) from the Staff Client so that the new data file is created
- The error message will display
- Close out the error message
- Locate your print templates by checking the Customization Manager under System | General | PrintDocumentsPath (Aeon & ILLiad) or System | Printing | PrintDocumentsPath (Ares)
- Consult the documentation to find the name of the template to open in the PrintDocumentsPath directory and the associated data file. For example, the ILLiad LendingLoanSlips.doc template merges with the Documents\ILLiad\Print\StacksL.xslx data file.
- Navigate to the document you need to print in File Explorer and double-click to open it. This should be a Word document file.
- If presented with a box that says “Opening this document will run the following SQL command....” click No and proceed with the steps below unless you have saved the document with the proper data source previously. If you have already run through this process and saved the template with the associated data source, you can click Yes and skip to the Finish and Merge step below.
- Open the Mailings ribbon at the top.
- Click the Select Recipients button and choose Use an Existing List...
- Navigate to the data source associated with the print template as specified in the documentation linked above. Data source files are .xlsx files located in Documents\ProductName\Print. (Ex. Documents\ILLiad\Print\StacksL.xslx.)
- Click Open
- If you get a popup box asking if you are using the PrintQueue or LegacyQueue, choose the appropriate one for your template, usually PrintQueue. If there is only one option in the popup box, select that option and click OK.
- Click Yes to merge with the data source if prompted
- Click Mailings on the menu bar then select Finish and Merge to choose to either Edit/Display the documents before sending them to the printer or Print without editing:
- Select OK to choose all records to merge
- Select a printer if necessary and print your document
- If you have adequate permissions, you can save this template with the associated data file so that you don’t have to link the data file with each printing. To do so, just click the Save option in Word.
- Repeat for each printing job