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.)
- From the Banner Main Menu, type GWR3PAL, then press Enter.
- Click the
- Complete the parameter values as shown below:
What to Type
05: Address Type
06: Sort Order
To sort labels by Zip Code, leave the default of Z
07: Delete Population?
- When you are finished entering the parameter values above, click the
- 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.
Open Report Viewer and find the name of this report on your list of reports. (The name will include "gwr3pal" in its title.)
Click on the "Label" link on the right side of the report line.
- Prepare your printer to print using Avery Standard Labels, size 5160.
Print the report.
For help with this process, contact the TSS Training Team.