Creating a New MS Word Template for RJS iSeries Office Integrator-MS Word XP - Support

Creating a New MS Word Template for RJS iSeries Office Integrator-MS Word XP

From Support

Jump to: navigation, search

1.) The first step to creating a new MS Word template is downloading a sample AS/400 database file in CSV format.

The following AS/400 command sends a sample customer file to the PC:

OFCDBSND RMTSYS(*CURRENT) FILE(QIWS/QCUSTCDT) DTAFMT(*CSV) COLHDG(*YES) RMTFIL('/customer.txt') USR(TEST) PWD(TEST)

2.) Launch MS Word XP.

Image:CreateNewMsWordTemplate.png 3.) Select Tools/Letters and Mailings/Mail Merge Wizard and select Letters for the document type. Image:CreateNewMsWordTemplate2.png 4.) Click next to go to Step 2 and select Use the current document. Image:CreateNewMsWordTemplate3.png 5.) Click next to go to Step 3 and select Use an existing list. Image:CreateNewMsWordTemplate4.png 6.) Click next to go to select a data source. Select c:\customer.txt as the data source Image:CreateNewMsWordTemplate5.png 7.) Click OK on the Mail Merge Recipients dialog and then start typing your letter. Image:CreateNewMsWordTemplate6.png 8.) Click next to go to Step 4 and type your letter template. Use the More items link in the wizard to insert merge fields. Image:CreateNewMsWordTemplate7.png Image:CreateNewMsWordTemplate8.png Image:CreateNewMsWordTemplate9.png 9.) Click next to go to Step 5 and preview the merged letter data. Image:CreateNewMsWordTemplate10.png 10.) Click next to go to Step 6 to complete the template setup. You can print or edit the merged document as required. Image:CreateNewMsWordTemplate11.png Save the new template file with a .DOT extension.

Your new MS Word XP mail merge template can now be used with the iSeries Office Integrator.

Personal tools