how to create labels in word 2016 from excel

Word will ask you to confirm the data in the file, which will then be prepared in the background for importing. Importing Contact Information into Word 2010 To import from Excel or Access, choose Use an existing list, then Browse… for the file. Data from other Word documents or HTML files can also be used. It is now time to choose your recipients – these can be selected from your Outlook contacts, or picked up from an existing list, typically in Access or Excel. At this point you will be asked to choose your paper format – select whatever is most appropriate for your task

At the next stage you will be asked whether you want to use the existing document or one that already exists – choose Use the current document and then move onto the next stage by clicking Next. The Wizard will appear as a right-hand column – choose Labels, then Next to continue. To begin, in Word go to the Mailings tab and select Start Mail Merge > Step by Step Mail Merge Wizard. With these, you can create a set of letters, emails or even envelopes. Performing a Mail Merge in Word 2010īefore performing a mail merge, you will need a source from which the mail merge will pick up the addresses you want to include. Let’s take a look at how to create a set of mailing labels with a few address imported from Excel.

Microsoft Word 2010 features a new version of the mail merge tool beloved of personal assistants, secretaries and administrative staff the world over. One popular task that has historically been performed as a two-handed procedure between Excel and Word is that of the mail merge – typically creating a set of address labels using data stored in a spreadsheet and imported into Word. This is in sharp contrast to the features of some of the older versions, which promised much but delivered little. This has led to several interesting new options, including the insertion of Excel tables and charts into a Word document.

Android P Beta 2 Out Now Here’s How to Install ItĪmong Microsoft Word 2010’s improvements is its integration with Microsoft Excel.

Here’s How to Get iOS 12 on Your Device Before the Official Roll Out.

How to create labels in word 2016 from excel