iSeries Office Integrator

In This Section

Cannot Access Remote System from iSeries Using System Name

Problem You cannot access a remote system from the iSeries by using the remote system's host name. Solution For information on IP addresses, system …
Format Excel Files Sent from Office Integrator

Problem Do you have a method of formatting information in Excel Spreadsheets when sending data from the AS/400 to a PC using Office Integrator? Solu…
32002 error from Outlook sending attachment via OFCRUNPC command

Customer was having a problem when trying to run the following command (modified for general use):

OFCRUNPC RMTSYS(*CURRENT) CMD('NEWMAIL~support@rjssoftware.com~ ~ ~Our Test Email~ ~C:\TEMP\Test.txt~1~1') OPTION(*OTHER)

They received Error 32002 "Unspecified Error" from Outlook on their PC.
Setting up iSeries Office Integrator on a Windows Terminal Services Server

These instructions show you how to set up iSeries Office Integrator on a Windows terminal server. Because a Windows terminal server runs multiple use…
Create a Named Ranged in a Spreadsheet to access via ODBC

To create a named range in a spreadsheet: Open Microsoft Excel and create a new spreadsheet. In the first row of the spreadsheet, type the column na…
Troubleshooting iSeries Office Integrator

Note: The following troubleshooting techniques rely on the QTEMP library on the iSeries. When an error message displays on the PC, leave it open. Thi…
Keeping Microsoft Word open for multiple Mail Merges

The iSeries Office Integrator can keep MS Word open after doing mail merges to maximize throughput. We added functionality for the MERGELETTERPRINT2 …
Creating Directories with OFCRUNPC Command in iSeries Office Integrator

With iSeries Office Integrator, version 1.1.63 or above, you can use the following parameters to create a directory on the remote PC: There are two pa…
CPF4101 in iSeries Office Integrator Joblog

Problem: While running iSeries Office Integrator connections cannot be made to the PC server and errors occur on the iSeries side. Joblog includes th…
Error 500 MS Word OLE error: 13 The data is invalid occurring when running back to back mail merges

Problem: When you run the MERGELETTERPRINT command back-to-back several times, after the second and subsequent merges within about 30 seconds, the …
Microsoft Word Mail Merge Tech Tip: Numeric Fields Not Displaying Currency Sign

Problem: Numeric Fields Not Displaying Currency Sign when doing a mail merge. Solution: TECH TIP: NUMERIC FIELDS NOT DISPLAYING CURRENCY SIGN To …
Errors when trying to do a MERGELETTERSAVE

Problem: Errors occured what using the OFCRUNPC with the parameter MERGELETTERSAVE.PC Command Error: 500 500 MS Word OLE error: 4248 This command is …
Merging, Printing and Saving via iSeries Office Integrator

Problem: How to merge into a Word template, print the document and then save the document via the iSeries Office Integrator. Solution: Note: Version …
Sample CL Program for Scanning Document Batches from an emulator with iSeries Office Integrator

Use the following CL program to scan batches of documents from any green screen program: Note: For a description of the parameters you can pass, see U…
5535 PC Command Error: 500 500 MS Word OLE error: 5535 Word could not finish merging these documents or inserting this database
PC Command Error: 500 500 Send email error: CreateNewMessage Error 32002 Unspecified Failure has occurred
Choosing the Printer Tray with OFCRUNPC or FTPRUNPC

Problem: When using iSeries Office Integrator or FTP Remote Command Server, you need to choose the paper drawer for printing. Solution: Prerequisit…
Automation Error when Launching Microsoft Word or Excel

Getting an automation error (-2147023067) when launching Microsoft Word or Excel from iSeries Office Integrator.
Using VBScript Macros with OFCRUNPC in iSeries Office Integrator

You can use custom VBScript macros with the OFCRUNPC command in iSeries Office Integrator. Prerequisites: iSeries Office Integrator PC Component …
Sending a File to a Network Drive Letter with the OFCDBSND Command

RJS Software has included a special command QUOTE SITE DRIVE in iSeries Office Integrator that allows you to send a file via FTP to any mapped drive …
Word OLE Error 5151 When Running Word Mail Merge with FTP Remote Command Server

Problem When trying to run the FTPRUNPC command with the MERGELETTERPRINT directive to automatically print the document after the merge completes, th…
Error 75 Path/File Access Error with Office Integrator

Problem: Error 75 Path/File Access Error recieved using OFFRUNPC command to do a File Copy from one IFS directory to another IFS directory. Solution:…

In This Section

Cannot Access Remote System from iSeries Using System Name

Format Excel Files Sent from Office Integrator

32002 error from Outlook sending attachment via OFCRUNPC command

Setting up iSeries Office Integrator on a Windows Terminal Services Server

Create a Named Ranged in a Spreadsheet to access via ODBC

Troubleshooting iSeries Office Integrator

Keeping Microsoft Word open for multiple Mail Merges

Creating Directories with OFCRUNPC Command in iSeries Office Integrator

CPF4101 in iSeries Office Integrator Joblog

Error 500 MS Word OLE error: 13 The data is invalid occurring when running back to back mail merges

Microsoft Word Mail Merge Tech Tip: Numeric Fields Not Displaying Currency Sign

Errors when trying to do a MERGELETTERSAVE

Merging, Printing and Saving via iSeries Office Integrator

Sample CL Program for Scanning Document Batches from an emulator with iSeries Office Integrator

5535 PC Command Error: 500 500 MS Word OLE error: 5535 Word could not finish merging these documents or inserting this database

PC Command Error: 500 500 Send email error: CreateNewMessage Error 32002 Unspecified Failure has occurred

Choosing the Printer Tray with OFCRUNPC or FTPRUNPC

Automation Error when Launching Microsoft Word or Excel

Using VBScript Macros with OFCRUNPC in iSeries Office Integrator

Sending a File to a Network Drive Letter with the OFCDBSND Command

Word OLE Error 5151 When Running Word Mail Merge with FTP Remote Command Server

Error 75 Path/File Access Error with Office Integrator

+1 800-328-1000

info@helpsystems.com

Cybersecurity

Compliance & Audit Reporting

IT Operations Management

IT Infrastructure Monitoring

Business Intelligence

Document & Forms Management