How can I print multiple names or lines on my address labels? (2024)

FAQs

How can I print multiple names or lines on my address labels? ›

The most common reasons why labels don't print in the right place are: Your printer settings are not adapted. Your labels contains too much text information or the font size is too big. You might not be using the correct label templates.

The most common reasons why labels don't print in the right place are: Your printer settings are not adapted. Your labels contains too much text information or the font size is too big. You might not be using the correct label templates.

With your address list set up in an Excel spreadsheet you can use mail merge in Word to create mailing labels. Make sure your data is mistake free and uniformly formatted. We will use a wizard menu to print your labels. Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard.

Avery Design & Print - Make Labels Online. Free software and templates.

A laser printer will print shipping labels much faster than an inkjet. If you print more than a couple of labels a day, you'll appreciate the difference. Printed text is sharper, even at tiny font sizes (which shipping labels use).

For instance, if you sell smaller quantities of seasonal products, printing your own labels can be a more cost-effective route. But once you start needing a larger number of labels on a regular basis, it's probably time to consider using professional printing services.

You can create Avery labels from an Excel Spreadsheet by using Mail Merge in Microsoft Word or by printing directly from Excel. From Word, you can choose different label brands and product numbers. You can select the Avery label template that suits your needs.

If you're using Avery Design & Print, select a text box, then click Start Mail Merge under the Import Data (Mail Merge) tools. The application will help you locate your file and upload the names. Then format the labels the way you want, and you're done.

What is the easiest way to print address labels? ›

Make it easy: Use a template

Start Word, or click FILE > New. Type Return address label in the Search for online templates box and press Enter. Click the picture of the template you want and click Create. In the first label, click each line of the address and type the information for your return address.

When printing Avery 5160 or other labels or reports where the position of the items on the page is important, be sure the printout is not scaled or reduced in any way, otherwise the labels may not line up to the printed text correctly when the document comes out of the printer.

Word adds blank labels to a new document. To see the labels, click the TABLE TOOLS LAYOUT tab, and click View Gridlines. Next, we need to add addresses to the labels, and we'll do that by creating a recipient list. Go back to the MAILINGS tab, click Select Recipients, and Type a New List.

Hold down the CTRL or SHIFT key to select multiple labels, and apply an attribute to more than one label.

Go to Mailings > Preview Results. Choose Preview Results again to view, add or remove merge fields. Select Update labels when done if you make changes. When the labels look the way you want, go to Mailings > Finish & Merge > Print Documents.