HOW TO DO MAIL MERGE IN WORD FOR LABELS DOWNLOAD

Templates are available for download in the Specs tab below the product image. If you are comfortable printing on our own, use our Microsoft Word envelope printing templates and instructions. Shop Envelope Styles Print at Home Using Envelope Printing Templates We recommend you take the time to check out all of our envelope styles, formats, and finishes, but below, we've listed some customer favorites. What does this mean for you? A seemingly endless variety of super fancy envelopes to complement your design! Our envelopes are made using our extensive collection of colorful specialty papers and in a variety of formats and flap styles. Shop Envelope Sizes Buy Top Quality, Premium, Thick Envelopes by Colors & Styles This gives you options, flexibility, and a source for those tough to find envelope sizes. At LCI, we offer not only the standard envelope sizes, but the not so standard ones as well. Find all the Standard Envelope Sizes (and then Some.)Д¬ards come in all shapes and sizes and so do our envelopes. Whether you buy your envelopes bulk or small quantities, your style traditional or trendy, your event personal or professional, we offer hundreds of top quality envelopes all at wholesale prices for you to choose from. In need of invitation envelopes? You've come to the right place. Once youвЂ™ve confirmed everything is set properly, click вЂњOK.Buy Invitation Envelopes Bulk or Small Packs, All At Wholesale Prices For example, вЂњFirst NameвЂќ should match with вЂњFirst Name,вЂќ and so on. In the вЂњRequired for Address BlockвЂќ group, make sure each setting matches the column in your workbook. In the вЂњInsert Address BlockвЂќ window that appears, click the вЂњMatch FieldsвЂќ button. Select the first label, switch to the вЂњMailingsвЂќ tab, and then click вЂњAddress Block.вЂќ Now itвЂ™s time to add your mail merge fields in WordвЂ™s labels. Step Four: Add Mail Merge Fields to the Labels Your labels are now connected with your worksheet. Make sure to enable the вЂњFirst row of data contains column headersвЂќ option if itвЂ™s not already and then click вЂњOK.вЂќ If you have multiple sheets in your workbook, theyвЂ™ll appear here. Use it to locate and select your mailing list file. Once youвЂ™re finished, your list should look something like this:ДЄ drop-down menu will appear. Once youвЂ™ve finished creating the headers, go ahead and input the data. RELATED: How to Create and Print Labels in Word You can even insert images in the mailing labels if you want, but that step would come later in Word. This is the standard information youвЂ™ll find on mailing labels. Our list will include the following headers: To properly illustrate the steps, weвЂ™ll go with a personal mailing list in this example. Also, if your list is for companies and not individual people, you can omit the вЂњFirst NameвЂќ and вЂњLast NameвЂќ header and just go with вЂњCompany NameвЂќ instead. Titles are always nice, but itвЂ™s important that you know which title a person goes by before creating the labels. Which headers you include depends on which information you plan to use in the mailing labels. Place those headers in the first row of each column. The first thing you need to do is create a column header respective to the data that goes in each column. If you havenвЂ™t created the list yet, despite ExcelвЂ™s lack of the mailing label function, we still highly recommend you use Excel since itвЂ™s better for organizing and maintaining data than using a Word table. If you have already created a mailing list in Excel, then you can safely skip this test.

How to do mail merge in word for labels