The steps required for creating labels with CIRS data on your laser printer using Microsoft Word and Excel are as follows:
Step 1:
Write and execute a report request that gathers the data needed for your labels and routes the output to a hold file. (See the example below.)
EX AC
TABLE FILE AC
PRINT AC:WNAME AC:WORKLOC
ON TABLE HOLD AS PERMSML FORMAT LOTUS
END
Step 2:
Download the data in your hold file to an Excel worksheet. Before saving your worksheet, insert a new row before the first line and label the data in each column. For instructions on using worksheets, refer to Help in Excel.
Step 3:
Next, use Word's Mail Merge function to create labels using the Excel worksheet as the data source. For instructions on printing labels by merging an address list, refer to Help in Word.
Last Updated: March 1, 2024