Uploading G Numbers into Banner to Create Mailing Labels

With an uploading process, Banner-users can import a group of G Numbers into Banner to create mailing labels. This involves four steps.


Steps 1 -- 3: Prepare the Data, Upload the Data, and Run the GWRPOPR report

Complete directions for Steps 1--3 are located on the main Banner Uploading Help Page.

 
Step 4: Create Mailing Labels

Once you have performed Steps 1--3, you can run mailing labels that specify the names and addresses of all students whose G Numbers you uploaded.

This mailing labels report (GWR3PAL) is designed to fit onto Avery Standard Address Labels, size 5160. (3 columns wide, 30 labels per page.)

Directions:

  1. From the Banner Main Menu, type GWR3PAL, then press Enter.
  2. Click the Next Block button TWICE to get to the "Parameter Values" block.

  3. Complete the parameter values as shown below:

Parameter

What to Type


01: Population Application Code


GENERAL


02: Population Selection ID


GWRPOPR_POPSEL


03: Population Creator ID


Type: COMMON


04: Address Effective Date


(Leave the default of today's date here)

05: Address Type


(Leave the default of 1MA here)

06: Sort Order

To sort labels by Zip Code, leave the default of Z
To sort by name, type N

07: Delete Population?


Leave default of N


  1. When you are finished entering the parameter values above, click the Next Block icon.

  2. Click the Save icon on the top left.


Printing Your Labels

Labels can be printed directly from Banner Report Viewer using Avery Standard Labels, size 5160. When this report appears in Report Viewer, you will see a "Labels" link just to the right of the blue dots.

  1. Open Report Viewer and find the name of this report on your list of reports. (The name will include "gwr3pal" in its title.)

  2. Click on the "Label" link on the right side of the report line.

  3. Prepare your printer to print using Avery Standard Labels, size 5160.
  1. Print the report.


For help with this process, contact the TSS Training Team.


11/19/15