|
|
Campus Information Retrieval System CIRS Human Resources, Data Operations |
|
User Manual | Data Element Dictionary | Tutorials | Systemwide HR | Support |
|
|
|
Campus Information Retrieval System CIRS Human Resources, Data Operations |
|
User Manual | Data Element Dictionary | Tutorials | Systemwide HR | Support |
|
The steps required for creating labels with CIRS data on your laser printer using Microsoft Word and Excel are as follows:
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.) For information on creating hold files and executing reports, refer to your CIRS User Manual.
EX AC
TABLE FILE AC
PRINT AC:WNAME AC:WORKLOC
ON TABLE HOLD AS PERMSML FORMAT LOTUS
END
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.
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.