N
Common Ground News

How do I mail merge address labels?

Author

Sarah Oconnor

Updated on February 23, 2026

How do I mail merge address labels?

Create your address labels

In Word, click Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard to start the mail merge wizard. Choose Labels, and then click Next: Starting document. Choose Label options, select your label vendor and product number, and then click OK. Click Next: Select recipients.

Regarding this, how do I mail merge address labels in Word?

Create your address labels

In Word, click Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard to start the mail merge wizard. Choose Labels, and then click Next: Starting document. Choose Label options, select your label vendor and product number, and then click OK. Click Next: Select recipients.

Secondly, how do I print labels from different addresses? Create and print a page of identical labels

  1. Go to Mailings > Labels.
  2. Select Options and choose a label vendor and product to use.
  3. Type an address or other information in the Address box (text only).
  4. To change the formatting, select the text, right-click, and make changes with Font or Paragraph.
  5. Select OK.

Also to know is, how do I mail merge Avery labels?

Merge your information

If you're using Avery Design & Print Online, 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!

How do I merge address labels from Excel to Word?

On the “Mailings” tab, click “Finish & Merge.” From the drop-down menu that appears, select “Edit Individual Documents.” Your list from Excel will now be merged into the labels in Word. All that's left to do now is print out your labels and send out your mail!

How do I mail merge labels from Excel to Word 2010?

Making Address Labels Using Address Blocks
  1. To start the Mail Merge for labels, you should already have an Excel spreadsheet with a list of all the addresses you want to use.
  2. Next, open up Word and click on the Mailing tab at the top.
  3. Click on Start Mail Merge, then select Step-by-Step Mail Merge Wizard.

What is mail merge and label generation?

A mail merge involves merging a main document with a data source. A main document contains the text and other items that remain the same in each label. Each row (or record) in the data source produces an individual label. Create an address book spreadsheet in Excel. This is your data source.

What are the six steps of mail merge?

There are six steps in the mail merge wizard:
  1. Select the document type.
  2. Start the document.
  3. Select recipients.
  4. Write your letter.
  5. Preview your letters.
  6. Complete the merge.

Where is mail merge Excel?

You can insert one or more mail merge fields that pull the information from your spreadsheet into your document. Go to Mailings > Insert Merge Field. Add the field you want.

How do I create an address mail merge from Excel?

Here are some simple steps for building and printing your mailing list in Excel:
  1. Step 1: Open Excel.
  2. Step 3: Type or paste in your customer or lead list directly into Excel.
  3. Step 4: Save your mailing list.
  4. Step 5: Open a MS Word document.
  5. Step 6:Go to the Mailings Menu > Start Mail Merge >Step by Step Mail Merge Wizard.

How do I make address labels in Google Docs?

when you're ready,
  1. create your mail merge content in a Google Sheet.
  2. open a new Google document.
  3. click on the Add-Ons menu.
  4. choose Avery Label Merge.
  5. choose New Merge.
  6. click on either Address Labels or Name Badges.
  7. choose the Avery label or badge that you want.
  8. choose the spreadsheet that has the mail merge information.

How do I mail merge Avery Labels 5160?

Head to the Mailings tab in the new Word document and select the Start Mail Merge option. Select Labels and click Label Options. This is where you format the Word document for the Avery 5160 labels.

Can you make Avery labels from an Excel spreadsheet?

If you use Microsoft Office, you can easily import addresses or other data from an Excel spreadsheet and place them onto Avery labels, name badges, name tags or other products to edit and print using Microsoft Word. See the steps to mail merge onto an Avery template, making preparing for mailings and meetings a breeze.

How do I convert a Word document to Avery labels?

With your Word document open, go to the top of screen and click Mailings > Labels > Options. (In older versions of Word, the Options setting is located in Tools at the top of the page.) Select Avery US Letter from the drop-down menu next to Label Vendors. Then scroll to find your Avery product number and click OK.

How do I print Avery labels with different addresses in Word?

Click “Mailings” at the top of the menu. Under the “Create” ribbon menu, select “Labels.” When the pop-up box appears, select “Full Page of the Same Label.” Click “Options,” choose the appropriate label size and click “OK.” Click “New Document,” and a new Word document will appear with the address label template.

How do I make different labels on the same page?

Under Pages, make sure to choose Multiple pages per sheet, and then click Print.
  1. Click File > New.
  2. Click Labels.
  3. Click to select a template, and then click Create.
  4. Click Insert > Page to add labels to your sheet.
  5. In the Insert Page dialog box, enter the number of pages that you want to add.

How do I print sticker labels at home?

Create Your Own Personalized Labels
  1. Step 1: Go Online. Open Avery Design & Print Online.
  2. Step 2: Enter Your Product Number.
  3. Step 3: Choose Your Template.
  4. Step 4: Personalize Your Labels.
  5. Step 5: Apply the Design to Individual Labels, or to All.
  6. Step 6: Preview & Print.
  7. Step 7: Save.
  8. Step 8: Continue to Create.

Related Documentation

How much does a limo cost for a funeral?

How do you know if you have breakdown cover?

Does Tahj Mowry have a kid?

How do I mail merge address labels?