However when you get ready to print mailing labels youll need to use mail merge to create them in word from your excel list. In the label options dialog box choose your label supplier in the label vendors list. How to create address labels from excel on pc or mac. To make mailing labels from excel your spreadsheet must be set up properly. Click tools mail merge manager or labels 1. If you already have a spreadsheet containing. Creating labels from a list in excel mail merge labels from excel. Now save it somewhere where you can easily locate it.
This wikihow teaches you how to create address labels from spreadsheet data using microsoft word.Ĭreate And Print Mailing Labels For An Address List In Excel Create a list in excel. You cant create labels in excel without having an excel spreadsheet first.
