Mailing Labels

Mailing Labels
Information Services does not offer label printing services. Individual departments and employees may print their own labels using data obtained from the appropriate resource, Microsoft Word & Excel, mail merge, and standard printer label templates. Below is information about where and how to obtain the data and how to do a mail merge. Links at the bottom connect to other related resources. The Information Services Help Desk can assist with the process and provide training on mail merge.


Contents

Where to get the Data
Mail merge
Standard Labels
Related Pages
External Links
Still Need help?


Where to get the data

  • For student and academic information use SQL Reporting Services.
  • For employee information request a spreadsheet from Human Resources. They will need at least a week lead time.

Mail merge

Basic steps:

  1. Set up your main document
  2. Open your data source
  3. Organize your data
  4. Insert merge fields
  5. Finish your merge and either print or edit

For detailed instructions, see this quick reference guide.


Standard labels

  • For full address use Avery #5160
  • For brief address (i.e. name and department or name and box number) use Avery #5267

Related pages


External links