Word OLE Error 5922

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

Word OLE Error 5922 Occurred while running a MS Word Mail Merge with FTP Remote Command Server

Customer gets the following error in their job log when trying to run the FTPRUNPC command with the MERGELETTERPRINT directive to automatically print the document after the merge completes:

                       Additional Message Information                         
                                                                              
Message ID . . . . . . :   CPF9898       Severity . . .  . . . . :   40         
Message type . . . . . :   Escape                                              
Date sent  . . . . . . :   06/25/02      Time sent  . .   . . . :   16:18:05   
                                                                               
Message . . . . :    FTP Command Error: 500 MS Word OLE  error: 5922 Word was unable to open the 
  data source..                                                            
Cause . . . . . :   This message is used by application  programs as a general  
 escape message.                                                              
                                                                              

The MS Word "File/Save As" dialog is also displayed in Word after this error occurs.

Solution:

Make sure the ODBC data source has been created for the MS Word Mail Merging. See the FTP/400 User Guide Getting Started Section for instructions on creating the ODBC data source.

Another possibility that we discovered is if they pass the database file (txt, csv) path using forward slashes ('/') instead of back slashes ('\') they can get the exact same error along with the Save As issue.

5/17/04 LDJ - Also found that if you have your template and data source saved on the C drive you will get the same error. Customer had was getting the 5922 error and we moved his files to a subdirectory and then it ran fine.