WebFOCUS Techniques

Creating Labels from WebFOCUS

Select a new program or use an existing program.
In the exercise below we will create a new program, then run the program to an Excel format, which will then be exported to labels in Microsoft Word.

1. Create your program.
2. Add necessary tables and fields to the program
3. Change the display type to Excel

5. After all options are set, run the program.
6. Select File>Save As
7. Make certain that the Save as type is set to Microsoft Excel Workbook (*.xls)
   This can be adjusted by clicking onto the upside down triangle to reveal a scroll list. Simply scroll up or down, then select Microsoft Excel Workbook (*.xls)
8. Enter file name in the appropriate box

9. After file has been saved we can then close the output window.
10. Open Microsoft Word.
11. Select Tools>MailMerge...>Create
12. Select the type of merge (Form Letters, Mailing Labels, Envelopes, or Catalog). A dialogue box will now open. Selecting Active Window: Merges information with the already open word document. Selecting New Main Document: Opens a new document to be merged with.
13. Select Get Data>Open Data Source…
    Change the Files of types: to MS Excel Worksheets (*.xls). Select the Excel file that was newly created by WebFOCUS.

14. A dialogue box now appears select "Entire Spreadsheet" or the range of cells that you would like to merge. Then click OK.
15. A dialogue box now appears: If you are printing labels select Set Up Main Document
16. Select the type of labels and where the labels are to be output.
17. A new dialogue box now appears.
    Select and insert merged fields as you wish to see the fields printed on the labels including punctuation and spacing.

15. Click OK. Labels are now formatted and are ready to be printed.
    
    *Please note: Blank lines in the address are suppressed.

MCIS Documentation and Information page at Miami University