Home > Common Problem > body text

How to Create and Print Avery Address Labels in Microsoft Word

WBOY
Release: 2023-04-14 17:58:14
forward
2103 people have browsed it

If you need to create Avery How to Create and Print Avery Address Labels in Microsoft Word How to Create and Print Avery Address Labels in Microsoft Word using Microsoft Word, then this article will help you do it. You don't need to download or own any additional software. Using Microsoft Word, How to Create and Print Avery Address Labels in Microsoft Word can be easily created and printed. Let’s look at the details of printing Avery How to Create and Print Avery Address Labels in Microsoft Word How to Create and Print Avery Address Labels in Microsoft Word.

How to Create and Print Avery Address Labels

Step 1: First, I have a Microsoft Excel with Name, Address, City, State, and Zip Code as column headers and in Some sample data is saved. We will further use this data as How to Create and Print Avery Address Labels in Microsoft Word information in How to Create and Print Avery Address Labels in Microsoft Word.

How to Create and Print Avery Address Labels in Microsoft Word

Step 2: Open Microsoft Word and click the File menu and then click Blank Document to create a new Microsoft Word document.

How to Create and Print Avery Address Labels in Microsoft Word

Step 3: Click the Mail tab at the top of the Word document.

How to Create and Print Avery Address Labels in Microsoft Word

Step 4: Click Start Mail Merge and select Labels## from the drop-down list

How to Create and Print Avery Address Labels in Microsoft Word

#Step 5: A label options window appears. Select

Avery US Letter from the Label Supplier

drop-down list. Step 6: Under the Product Number box, click to select the appropriate product number. The product number is a four or five digit number that is usually printed

on the front of Avery product packaging. Here I want to select the 5160 How to Create and Print Avery Address Labels in Microsoft Word tag

Step 7: Click

Confirm

How to Create and Print Avery Address Labels in Microsoft Word##Step 8: Now, import the data saved in Microsoft Excel into Microsoft Word where the above design is set up.

Step 10: To do this, click

Select recipients in the Mail tab on the same Microsoft Word document

Step 11 : Select

Use existing list from the drop-down list that appears

How to Create and Print Avery Address Labels in Microsoft WordStep 12: Now browse to the location where you saved Microsoft Excel and

Select

Excel and click to open.

How to Create and Print Avery Address Labels in Microsoft WordStep 13: A select table window appears,

Select the

Excel worksheetthat has saved the required data, and make sure Check the box next to "The first row of data contains column headers" because we have already set the column headers in Excel (name , How to Create and Print Avery Address Labels in Microsoft Word, city, state and zip code) Step 14: Click OK

.

Step 15: Now you need to merge the fields, so click How to Create and Print Avery Address Labels in Microsoft WordInsert Merge Fields# in the #Mail

tab

##Step 16: Insert merge fields for inserting name, How to Create and Print Avery Address Labels in Microsoft Word, city, etc., so the first row is the name, the second row is the How to Create and Print Avery Address Labels in Microsoft Word, and the third row is the city, state, and zip code. Step 17: Select "Name"

from the "

Insert Merge Field

" drop-down list and press

Enter. #Step 18: You can see the name appear in the Word document. Click

again to insert the merge field and

select the How to Create and Print Avery Address Labels in Microsoft Word How to Create and Print Avery Address Labels in Microsoft Word from the drop-down list.

##Step 19: Click to insert the merge field,

select the

city from the drop-down list, How to Create and Print Avery Address Labels in Microsoft Wordclick the keyboard The

Space

key on the key gives a space and then selects the status from the Insert Merge Field drop-down list, gives a space and then selects from Insert Merge Field Postal CodeStep 20: Now the first tab in Microsoft Word has all the column headers present in Excel. Step 21: Again, we want to update all How to Create and Print Avery Address Labels in Microsoft Word, so click "

Update Labels" in the Mail tab.

How to Create and Print Avery Address Labels in Microsoft Word

#Step 22: By doing this, all tags are updated.

update_How to Create and Print Avery Address Labels in Microsoft WordStep 23: Click

Preview Results in the Mail tab.

Step 24: Now all tags have the required data ready.

How to Create and Print Avery Address Labels in Microsoft Word

Step 25: Click Finish & Merge and select Edit Individual Documents from the list.

How to Create and Print Avery Address Labels in Microsoft Word

Step 26: Click the radio option button next to All in the window that appears To merge all records.

How to Create and Print Avery Address Labels in Microsoft Word

Step 27: Prepare the label paper or mailing label for printing. Press the Ctrl P keys simultaneously to get the print window

Step 28: Select the correct printer and click Print.

The above is the detailed content of How to Create and Print Avery Address Labels in Microsoft Word. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:yundongfang.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template