Excel can be used to create labels using data from a sheet. If you are skilled in VBA and Excel programming. Otherwise, just use the tool designed for the job. Presumably, if you have Excel, you also have Word. Word has a Mail Merge feature which 1) has a section for creating labels (even matching to commercial label part numbers and sizes), and 2) has a Wizard to guide you through the process. A feature of this in Word is that you can use an Excel spreadsheet as the data source for the merge. A web search will show you that others have done this without Word, pure Excel using VBA. But it doesn’t sound as if you are a programmer who could do this yourself in VBA. Go through the door rather than butting your head against the wall. Use Word’s Mail Merge. Answering. “How do I do a mail merge for labels from Excel?”
If you have a sheet of values (in Excel) and you want to use the mail merge tool. The tool is called “Excel VBA Mail Merge” in Word. 1. In Word, press “F9” and select “File” ‐> Import. 2. In Window 7: Click on “File” Click on “Import…” Click on the “Excel” (the name appears in the pop-up window) name. 3. Under “Import Options,” click on “Advanced…” Click on “Merge Files From” next to “Include this file: in the File Names” Click next to “Merge Files” Click on “Merge All Files” Click on “Merge to” and check the box. 4. Click on “Merge” (see picture to right). Excel VBA Mail Merge will ask you to click the “Copy” button. Then select “From” > “Excel VBA Mail Merge” file on the left end of the dialog box and click “OK.” 5. Under “Merging and Exporting” click on.