how to print address labels in word 2013 from excel

Make sure:Ĭolumn names in your spreadsheet match the field names you want to insert in your labels.Īll data to be merged is present in the first sheet of your spreadsheet. Here are some tips to prepare your data for a mail merge. To create and print the mailing labels, you must first prepare the worksheet data in Excel, and then use Word to configure, organize, review, and print the mailing labels. The mail merge process creates a sheet of mailing labels that you can print, and each label on the sheet contains an address from the list. If you want to send a mass mailing to an address list that you maintain in a Microsoft Excel spreadsheet, you can use a Microsoft Word mail merge. This simply means that the gridlines need to be turned on for Microsoft word, just follow the instructions above and you should be all set, or give our team a call for free support to help you with your setup.Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 More. Each of the products contain their own template, so once you've found the label or size you are looking to print on, you can then down load the MS Word file version or any version that best fits your needs.ĭon’t be alarmed if you’re trying to open the template in Microsoft Word and the document opens to a blank page. You can also find Avery label sizes in alternative labels of the same size with templates at the bottom of the Sheet Labels product pages. Have you chosen a few different label sizes? Are you in a time crunch where requesting samples of exact sizes may take too long? The printable templates are perfect for quick measurements, and you can even practice printing them on blank paper for printing setup.Ĭhoose a label size template - click here with the easy size range finder to narrow your search across standard label sizes, or use the exact size tab to enter an exact size. Looking to save yourself time with an easy solution? Using the templates provided by is the perfect way to do that. Use Free MS Word Label Templates & Make Printing Labels Easy How To Turn On Label Gridlines in MS Word: Using label printing templates for Word is a great place to start, and with all recent MS Word versions the templates will automatically open with gridlines visible. Ready to print your labels from MS Word, only to find out you have a blank page? Turning on the gridlines for label printing in Word can be easy with the right tools.

Sort by a variety of label uses to find the perfect solution for your label needs. Great for larger quantities, machine applied labeling, custom sizes & laminated options available. Great for any square or rectangle shape, hand applying labels, any quantity. Great for applying labels by hand & printing on demand. Avery Labels Cross Reference List ®Ĭhoose from any quantity, materials, shapes, sizes and colors.

How to print address labels in word 2013 from excel