AVERY TEMPLATE 5160 FOR WORD DOWNLOAD HOW TO
AVERY TEMPLATE 5160 FOR WORD DOWNLOAD ZIP

Browse for your CSV file that contains the names and addresses of your recipients. Step 5: Go to the Reference tab and click on Mail Merge > Open Source. Step 3: Set the Page settings, Margin settings and insert a table. Step 2: Open WPS Writer and create a new document for your labels. Save this spreadsheet as a CSV file in a location you can access later. Step 1: Open WPS Office and create a spreadsheet with the names and addresses of your recipients. This way, you can create personalized and professional-looking labels for mailing, shipping, or organizing purposes. 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 FOR WORD DOWNLOAD ZIP

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

AVERY TEMPLATE 5160 FOR WORD DOWNLOAD 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. When the world started its digital transformation, one of the first things to get off the market was traditional mail.

Avery template 5160 for word download