Avery 5160® Compatible 1” x 2-5/8″ White Address Labels – 30 Labels Per Sheet

FAQ

• How do I print 30 labels per page in Word?

  1. Run Microsoft Word from your computer and open a New or Blank document. 
  2. Go to Mailings on the Menu bar at the top of the document page and click Start Mail Merge.
  3. From the drop-down section, select the Step-by-Step Mail Merge Wizard option at the bottom.
  4. Note: After selecting Mail Merge Wizard, a command panel called “Mail Merge” will pop up from the right-hand corner. It lets you choose the type of document you want to use. 
  5. In the Mail Merge command panel, select Labels as the document type and then click on Next: Starting document at the bottom. 
  6. A series of options for setting up your documents will appear on your screen. Click on “Change document layout,” followed by Label options at the bottom.
  7. Select the type of printer you want to use from the “Printer Information” section. For standard printers, choose Page printers. 
  8. A “label options” window will appear. Click on the “Label information” section and choose Microsoft from the list of label vendors. 
  9. Choose your label’s product number from the “Product number” list and then select 30 per page as your label options. 
  10. Click OK to save changes.
  11. Click on Print, and your laser and inkjet printer will start printing your 30 label sheet.

• How to print the Address Labels from Excel?

  If you have an address list set up in an Excel spreadsheet, Outlook Contacts, or a new list you made, you can use mail merge in Microsoft Word and print them as mailing labels. Here’s how it works using a Windows::

  1. Go to Mailings > Start Mail Merge > Labels. From the Label Options dialog box, select your label supplier in the Label vendors list.
  2. Under the Product number list, select the product number on your label package.
  3. Note: If you can’t find your labels, select New Label, type in your label information, and enter a name for the label. Select OK to add the new label on the existing Product number list.
  4. Select OK. Your document is now displaying a table with an outline of the labels. 
  5. Note: If there’s no table, go to Table Layout and click View Gridlines.
  6. Go to File and click on Save to save your document.
  7. Go to Mailings, Select Recipients, and then select an option.
  8. Click on OK.
  9. Go to Mailings. Select Address block for just an address or choose Insert Merge Field for other merge fields.
  10. Format the fields in the first label. The look will be the same for the rest of the other labels.
  11. Choose Mailings > Update Labels.
  12. Click on Mailings > Preview Results. Select Preview Results again for viewing, adding or removing merge fields. Click Update labels after completing any changes.
  13. Click on Mailings > Finish & Merge > Print Documents

• How to print the Address Labels on a MacBook pro?

  If you have an address list set up in an Excel spreadsheet, Outlook Contacts, or a new list you made, you can use mail merge in Microsoft Word and print them as mailing labels. Here’s how it works using a Macbook Pro:

  1. Go to Mailings > Start Mail Merge > Labels.
  2. Under the Label Options dialog box, select your label supplier in the Label products list.
  3. Under the Product number list, select the product number on your label package.
  4. Note: If you can’t find your labels, select New Label, type in your label information, and enter a name for the label. Select OK to add the new label on the existing Product number list.
  5. Select OK. Your document is now displaying a table with an outline of the labels.
  6. Note: If there’s no table, go to Table Layout and click View Gridlines.
  7. Go to File and click on Save to save your document.
  8. Go to Mailings, Select Recipients, and then select an option.
  9. Click on OK.
  10. Click on Mailings > Insert Merge Field and choose the fields to display on your labels.
  11. Select OK.
  12. Format the fields in the first label. The look will be the same for the rest of the other labels.
  13. Choose Mailings > Update Labels.
  14. Click on Mailings > Preview Results. Select Preview Results again for viewing, adding or removing merge fields. Click Update labels after completing any changes.
  15. If the labels look good, click on Mailings > Finish & Merge > Print Documents