Create labels in word 2016 from excel how to#

Under Select document type, clickВ Labels.

Start Microsoft Office Word 2007 and Microsoft Word 2010, click the MailingsВ tab, click Start Mail Mergein the Start Mail MergeВ group, and then click Step by Step Mail Merge Wizard.

Start Microsoft Office Word 2003 or an earlier version of Word, point to Letters and MailingsВ on the ToolsВ menu, and then click Mail Merge Wizard.

Create labels in word 2016 from excel how to#

After you create your Excel data file, save it, and then close the data file.ДЇor more information about how to create a mail-merge address list, click the following article number to view the article in the Microsoft Knowledge Base: 294688В How to design and set up a mail merge address list in Word 2002 back to the top Step 2: Set Up the Main Document.2ASeattle14222USAFullerAndrewVice President, Sales1235 Main St.Tacoma14222USALeverlingJanetSales Representative1235 Elm St.Kirkland14222USAPeacockMargaretSales Representative1236 Main St.Redmond14222USABuchananStevenSales Manager1237 Main StLondonSW2 8MRUKSuyamaMichaelSales Representative1238 Elm St.LondonEC3 7HRUKKingRobertSales Representative1239 Main St.LondonRK2 9NPUKCallahanLauraInside Sales Coordinator1230 Elm St.Seattle14222USADodsworthAnneSales Representative1231 Elm St.LondonWG2 7LTUK Last NameFirst NameTitleAddressCityPostal CodeCountryDavolioNancySales Representative1234 Main St. Create your Excel data file, and arrange it by using the fields that you want to use for your label, as shown in the following sample data file:.To arrange your Excel data file, follow these steps: In a mailing list, for example, each row may include information about a particular recipient. Each row must provide information about a particular item.For example, Title, Salutation, First Name, Middle Name, Last Name, Address1, and Address2. The first row should contain field names for each column.Note the following requirements for the data table: The text in an output document can be the same in all output documents, but you can apply formatting to specific documents.Д«ack to the top Step 1: Set Up the Excel Data FileД«efore you proceed with the Mail Merge Wizard, make sure that your Excel worksheet is well structured for this purpose.

The output documents are the result of the mail merge.This database is typically a list of names, addresses, and phone numbers. The recipient list is a database-for example, a Microsoft Access 2002 database file or an Excel workbook-that contains the data that is to be merged into the output documents.It may contain a letterhead, text, and instructions in вЂњmerge fieldsвЂќ for inserting text (such as recipient names and addresses) that varies from one output document to another. The main document contains the basic text that is the same in all of the output documents.

When you use the Word mail merge feature, Word merges a вЂњmain documentвЂќ with a вЂњrecipient listвЂќ to generate a set of вЂњoutput documentsвЂќ: This article contains instructions that you can use to create such a list. You can use the Mail Merge feature in Microsoft Word to create and print labels for a mass mailing by using data from a Microsoft Excel worksheet.

Step 7: Preview the Labels and Fine-Tune the Recipient List.

Step 5: Arrange the Content of Your Labels.

This article was created by Microsoft, the original address is: