Avery template 5160 download for word how to#
Avery template 5160 download for word zip#

You can also use a spreadsheet that contains the names and addresses of your recipients as a data source for your labels. If you want to create address labels in WPS Office, you can use WPS Writer, a word processor that can handle various types of documents, including labels. Logo Advanced Create Labels in Word Creating Address Labels Step 19: Now go to the Mailing tab again, and click on “View Merged Data” to view the actual names, addresses, and others that were exported from the labels spreadsheet.Īnd there you have it-your very own personalized Avery labels have been created with WPS Office, ready to be printed and shared with everyone. Step 18: Copy and paste the selected text to each label section in our table. Step 17: Select all text using cursor and go to the Home tab to change the font style and font size as you wish. Step 16: Now arrange each field in separate lines within each cell of the table. Select each field and click on Insert for each field and close the pop up. Step 15: Add all the fields from the spreadsheet: name, address, state and zip. Step 14: In the ribbon menu, click on the “Insert Merge Field”.

Step 13: Click on “Open Source” and browse for the spreadsheet saved in step 1 with labels data. Step 12: Go to the Reference tab and click on “Mail Merge” in the ribbon menu. Step 11: Go to the Column tab next and set the width of the column as 6.40 cm.

Make sure the box labeled 'Specify height' is selected. Step 10: Go to the Row tab and set the height of the rows as 3.30 cm. Go to the Table Tools tab and click on “Table Properties” in the ribbon menu. Step 9: Now we have to set the table properties. Go to the Insert tab and click on “Table” to insert a table of 4 x 3 cells in our document. Step 8: Next we will be making guidelines. Step 7: Now go to the Margins tab and set the top, left and right margins as 0.5 cm and bottom margin as 1.5 cm. In the width and height fields enter 20cm. We will be setting the paper size as 20cm x 20cm. Step 6: The Page Setup window will pop up. Step 5: Now select “Size” in the ribbon menu and click on the “More Paper Sizes” option. Step 4: In the Margins drop-down menu, select “Narrow”. Step 3: Go to the Page Layout tab and click on “Margins” in the ribbon menu. Step 2: Create a new word document in WPS Writer to make labels. Save this sheet as a CSV file in a location you can access later.

Avery template 5160 download for word zip#

Step 1: Open WPS Office and create a sheet with the names, addresses, states and zip codes of your recipients.

Avery template 5160 download for word how to#

In this section, we will show you how to create Avery labels in Word using WPS Office by setting up a Word document, adjusting margins, inserting a table, utilizing Mail Merge, and arranging fields for clean, professional labels in a few simple steps: How to Create Labels in Word Using WPS OfficeĬreating labels in Word using WPS Office is a simple and convenient way to design and print your own labels for various purposes. In this article, we will learn how to create labels in Word using WPS Office, exploring their utility not only in conventional mailing but also as a means of brand labeling. Mailing with labels empowers users to seamlessly incorporate external information, crafting documents primed for postage. Yet, the potential of mailing goes beyond just letters. Use the Microsoft Word's Find and Replace formatting tool to replace all the pre-designed template text in each label with your own information.When the world started its digital transformation, one of the first things to get off the market was traditional mail.Continue with Step 3 until all labels are filled with your information.Position the cursor in the next label, right-click and select Paste.Highlight all the content in the first label, right-click and select Copy.Insert your information on the 1st label.How to create a sheet of all the same labels: Then click Text Wrapping and select In Front of Text in the drop down list. Select your image in the template and click the Page Layout tab in the Ribbon Toolbar. Highlight the text you entered and use the tools in Microsoft Word to format the text.Ĭlick the Insert tab in the Ribbon Toolbar to insert your own image, clip art, shapes and more. Once the file is open, type your information into the template. If the template looks like a blank page, select Table Tools > Layout > Show Gridlines to view the template layout. Double-click the Avery Word Template file you downloaded and saved to your copmuter.