How To Mail Merge Avery Labels In Word

Create the labels for mail merge as usual. Using Tabs in Word like Firefox, Chrome, Internet Explore 10. Click on Labels in the Start Mail Merge dropdown and the Label Options dialog will appear From the Label vendors dropdown, select either Avery A4/A5 or Avery Letter, depending upon your location and then select the Product number for the labels that you want to use from the list below. Click Label Options. you can fill in each label with custom text and insert content from an image or PDF. Fill the Labels radio button In the Task Pane. avery label 5162 template for word mail merge ms word {Label Gallery} Get some ideas to make labels for bottles, jars, packages, products, boxes or classroom activities for free. Create Mailing Labels in Word using Mail Merge from an Excel Data Set. (It is like 3 columns and 10 rows rows of stickers. This guide will explain how to use Mail Merge to combine a Word label template with a saved list of addresses to create individual address labels. Using Avery J8162 labels and MS Word 2010. Mail Merge from Excel to Word can be a real time-saver when it comes to sending large mailings. You can use mail merge in Office 2016 to create form letters or address labels, certificates with. In the Type dropdown list, scroll through the billions of labels. After your labels are set up, you”˜re ready to print. doc is all setup ready to perform a merge. (See Figure 2. To see the contents, press F4 to view your data sources. list of addresses) from Excel or Outlook Contacts. If you use labels, you need to know how and why to fix the margins. Select Change document layout. Click the Mailings tab. How to mail merge using Word & Publisher Mail merge tips According to wikipedia. Question: Q: mail merge anyone know how to merge a document from numbers to create a mailing address labels? i've tried several times i either get a document with only one address on it or i get an entire page filled with the same address for each entry. Open the "Label Vendors". Place the cursor where you want to position your image. But before you can get started with designing, you need the template. The only information you are going to need to begin producing your address labels in Word 2010 is the type of label that you are using. 3) Defining the Merge Fields in the label template. It is generally easier to do a Mail Merge in Microsoft Publisher® than trying to use Microsoft Word® to mail merge. How do I create and print an Avery 8168 label in word. The great Christmas card debacle of 2002 demonstrated to many people what a dog's breakfast Microsoft had made, of what was a relatively simple procedure in Word 97/2000 …. Word adds blank labels to a new document. For example if you have not purchase any yet, see the suggestion below for a Christmas Tree address label that uses Avery 5160, 5260, 5660 and so on (see details on screen shot below). Follow these steps: Start a new blank document. Select Step by Step Mail Merge Wizard. But before you can get started with designing, you need the template. csv file based on formatted label data from CDS. Typing a page of labels can become tedious and inefficient. Then under options, you can select the label layout if you know the equivalent Avery code. Avery will soon be retiring their Add-in wizard in Word. Here's how to use it. Create a blank document in Word 2011 and click Tools. All the code is contained in an Excel VBA module. Step Four: Click Setup in Section 1. Office 2000, Windows XT Tablet, all updates are current, Any suggestions?. Click OK to send the labels directly to the printer. Mail Merge Toolkit v. We'd like to thank Avery Wizard for its many years of service, but the software is now retired. doc is all setup ready to perform a merge. So feel free to download the one, most appropriate for your installed version of MS Word. The Label Options dialog box. How do I create and print an Avery 8168 label in word. Another Way to Merge with Word and Excel 2007. Select avery compatible label templates. Your printer may be slightly off so you may have to go back to re-align the labels to the page by a few millimeter or so. Select Type [user]. Word’s Labels tool can create templates for a variety of popular adhesive label sheets from Avery and other office-supply companies, including the common Avery 5160 style that fits 30 labels per sheet. In the Mail Merge Contacts dialog, select which contacts to use. To save addresses that are contained in a Word mail merged label document to an Excel workbook, follow these steps, as appropriate for the version of Excel that you are running. Some titles only have around 5 copies and other have over 200. Problem printing envelopes from a label template, Word 2010 … Options window, it puts my page of labels into #10 envelope-sized partitions. Time to create Mailing Labels? If so, did you know that your Microsoft Office Word has its own label wizard app, which is very powerful for designing and creating labels, including mail merge? How to Create Mailing Labels in Word. (Pressing Ctrl+N is a quick way. If it is important, I'm using a Mac with MS Office 2011. Mail Merge involves creating two documents. Select labels. Adobe premiere pro cs3 download trial microsoft office word 2007 templates free key premiere pro v5 free mac ms word 2007 mail merge tutorial pdf autodesk. Using Mail Merge is one of the best ways to print 4up place cards all at once instead of typing in the name and table number for each card. Create Avery labels, envelopes, and e-mail merges for your contacts in Microsoft Outlook. That completes. Easily design and print Avery labels, cards, name badges and more using our Easy Merge Excel ® add-on. There are many standard label sizes to choose from. On the Mailings tab, in the Start Mail Merge group, click Start Mail Merge. When the label is about to be changed you will be warned that the contents will be deleted. com Barcode on Laser Address Labels: designed to work with Mail Merge: ideal for tagging documents with barcoded labels: this version is compatible with 4" x 1¹/3" labels produced by a variety of label manufacturers, such as, Avery #05162, Staples #479878, Grand & Toy #99190. first name last name address etc. On the Reports menu, point to Mailing Labels and click one of the following options: Mailing Labels - Rejects. A main mail merge document in Word contains two important things: 1) the text that will remain the same between the personalized copies, and 2) the codes that tell Word what fields to insert at what points. By using Mail Merge you can rearrange information into a new format using fields taken from a database at the touch of a few buttons. Avery labels and Microsoft Word 2010 can work together very well when you have the correct label template for the labels that you are trying to print. How to Mail Merge Labels - Older Versions of Office/Word How To Create Mailing Labels In Word and Add 'and Family' To Their Name. Start Mail Merge; Labels; Avery 5960; I get a page of labels with <>. If you use Microsoft Office, you can easily import addresses or other data from an Excel spreadsheet and place them onto Avery labels, name badges, name tags or other products to edit and print. On the Mailings tab of the ribbon select the Start Mail Merge icon to choose the document type - here labels. Time to create Mailing Labels? If so, did you know that your Microsoft Office Word has its own label wizard app, which is very powerful for designing and creating labels, including mail merge? How to Create Mailing Labels in Word. Describes how to create envelopes by using mail merge in Word. Once you're in Word, if the "Mail Merge Manager" doesn't appear, select it under the "Tools" menu. Avery label codes are listed in the table below and in all our product descriptions. I choose the avery 5160 label template - 30 labels a page. 5 I want to make name tags and insert a picture background and make it transparent. Mail merging is perfect for producing address labels, invitations and mass mailings, and Avery’s free Design & Print software includes this feature within it. Then click 'Start Mail Merge' and select 'Labels. Print Labels from Avery. How To Create Microsoft Word Labels Using Free Avery Label Download. NET object as mail merge data source. On the Standard toolbar, click New. The more common method of creating labels is, of course, to use the Mail Merge feature of Word. How do I create and print an Avery 8168 label in word. Create Mailing Labels using SUPER and Mail Merge (Word 2010) For this example we will be using a 4-H club to generate labels for a mailing to the members. create a mail merge with gmail and google drive docs excel label template mail merge for mac labels medium maker download label e word mailing custom address template download avery free design & print template software simple gift certificate template word card place wedding free manage ssl certificates mail merge in microsoft fice word 2007. In Word on the Office Ribbon click Mailings, Start Mail Merge, and then labels. File > New > Labels and select the Labels Tab. Everything works fine but the printed labels aren't legible by the bar code readers. For example, I am using a sheet of 5160 labels from Avery, which is a sheet of 30 - 1″ by 2 5/8. To use the Mail Merge Manager to create mailing labels, follow these steps: On the View menu, click Print Layout. How to print Avery Mailing labels in Word? How to Find and Open an Avery Template in Microsoft® Word. Click on the "Mailings" tab, select "Start Mail Merge" and choose "Labels. Avery 5160 and 8160 are the most common. Easily design and print Avery labels, cards, name badges and more using our Easy Merge Excel ® add-on. Find the DDE for Excel. Then I added the Merge Fields manually after opening it. For example, you might want to create mailing labels from the customer information stored in a Visual FoxPro table. You can also use Avery Wizard to create a reusable list of addresses that you can then merge onto labels. You can also use. How to Mail Merge Address Labels Using Excel and Word - Steps Create an address file in Microsoft Excel by inserting names and addresses in the following manner: Open Word and go to "Tools/Letters" and "Mailings/Mail Merge". Choose from hundreds of designs and templates; Add text, colours & graphics; Import contacts and data with mail merge. Formatting and Printing Tips for 5 Index Tab and 8 Index Tab Inserts and Labels. For info about merging data with labels, see Create mailing labels in Word by using mail merge or Mail merge in Word for Mac. Word displays the Label Options dialog box. We have thousands of great designs to help spice up your labels. So be patient. Using Mail Merge is one of the best ways to print 4up place cards all at once instead of typing in the name and table number for each card. To do this, create a new document in Google Docs and look towards top of the window. I refuse to pay twice for the product but to each their own. Click Button1 to start Word Automation and to perform the mail merge. On the Tools menu, click Mail Merge Manager. NET source code to create mailing labels or customized letters using MS Word MailMerge This VB. How to create and print Avery address labels in Microsoft Word About this tutorial: Video duration: 4:5 This is a tutorial showing you step by step how to print address or mailing labels on Avery Mailing Labels in Microsoft Word 2016. Address Label Mail Merge Tutorial Mailing Address Labels For Parents Via Mail Merge How To Print Labels In Word, Pages, And Google Docs How To Make Mailing Labels Using Word 2011 Learning Microsoft Office Package Tutorial 45: How To Create Address Label. The ribbon toolbar displays the mailings options: Click Start Mail Merge and select Letters (or whichever document type you are creating). Insert picture background in Word mail merge labels I am using Word 2008 for Mac running on Max OSX 10. To use it, you must have a "new" Google Spreadsheet, and install the add-on via the Add Ons menu: Search for Mail merge, and you'll find several options. This helps to create personalized letters and pre-addressed envelopes or mailing labels for mass mailings a word processing document which contains fixed text,. avery 5160 mailing labels software free download - MS Word Mailing Labels Template Software, MS Word Shipping Labels Template Software, HomePrint Labels, and many more programs. WHERE DO I FIND THE TEMPLATE FOR AVERY 5567 TABS. Avery Label Merge requires a header at the top of each column. The avery wizard helps a lot with creating labels the way you want them. Find the label number on your box of labels. If you need help with that, see Mail Merge Labels with Word XP or Mail merge labels with Word 2007 a nd later versions I have also produced a tool to make it relatively easy to extract the Outlook Contacts data to an Excel worksheet, which would be useful when using the Merge with Attachments and Many to One Merge tools available elsewhere on. Can I do it direct … read more. Importing Excel database to Word for labels by ac85282 because there is no hint in your post that you can mail-merge to a letter but have problem to do it to labels. This wikiHow teaches you how to set up and print a template for a single label or multiple labels in Microsoft Word. Is there a work-around for this?. ) If you’re. Oh okay so it is working rightMicrosoft can't make their previews work right in the Mail Merge for 2007, so here is what I did: Open a Blank Word Document; In the ribbon bar click the Mailings Tab; Click the Start Mail Merge dropdown button. Mail merge is the process of merging information from a database into a text document, and then printing the document. Mail Merge Labels in Word 2007, 2010, 2013, 2016 - The Easy Method - Duration: 8:21. Under the "Tools" menu, click on "Microsoft Word:mac", then "Create Mail Merge". In the example below MailMergeLayout. Use your Excel file as your DATA SOURCE. Why is it normal for Writer to insert blank pages when merging data? [closed]. The material is both laser and inkjet printer compatible. Computerhope. Mail Merges in OpenOffice. Create Mailing Labels in Word 2003 With Mail Merge. Mail Merge Tips from Experience. In the following article, we tackle some frequently asked questions related to mail merge and step-out how to create mail merge labels in every version of Microsoft Word. Pluralsight. org and StarOffice provides a detailed description of the mail merge feature from start to finish. I would appreciate any help. The Mail Merge task pane opens. Click on the Mail Merge button on the Home tab. Browse to the Patient List file in My Documents 11. If you plan on doing one page of labels at a time keep the tray on Manual Feed, otherwise select Default. Mail Merge is a must when it comes to printing labels. Here, one can create a batch of letters, emails, envelopes, or labels. Open Word 6. For tutorials on mail merge, please visit this page. By using an Excel spreadsheet and the Mail Merge tool in Word, you can easily cut down on the time you spend addressing envelopes. This is a simple straight-forward task using the Avery template in Writer (Word). > In Word 2007, using an existing merge document and Access data, I am unable > to use the "update labels" command to make changes in the label format. Mail Merge in Word 2016 Mail Merge allows you to create multiple documents based on information contain in two different files. Avery Dennison has free download that facilitates printing mailing labels. Avery labels provide greater adhesion than basic labels with Ultrahold permanent adhesive that sticks and stays, guaranteed. Create a Excel layout like mine above and fill in the info. If you close it, the next step won't work. A Main Document (Mail Merge File) and a Data Source. Prepare the data source. Create the labels for mail merge as usual. If you have a mailing list already established, then you can easily merge the addresses to an MS Word document of any type. If you want to make return address labels, see Create return address labels. The mail merge process basically involves connecting a Word document and a The data source can be a simple table in a Word document, an Excel worksheet, 6 steps make it a simple case of choosing the document type (letters, labels etc. A "fast" option is also available to use with dot-matrix printers which bypasses Windows and prints raw text directly to the printer. You will use this pop-up window to choose your type of label. This guide will explain how to use Mail Merge to combine a Word label template with a saved list of addresses to create individual address labels. Select Start Mail Merge. Basic File folder labels in PDF templates ready for you to print on your laser and inkjet printers. These instructions will guide you through changing your label settings in Word 2013. This course covers how to create a recipient list within Word or retrieve an existing contact list from Outlook, and then use the list in Mail Merge to address labels or envelopes. If you mean that they are not the correct size. csv file based on formatted label data from CDS. From the Label Vendors drop-down list, choose Avery us Letter; in the Product Number list, choose 5160 Easy Peel Address Labels; click OK. I have a Dell printer and laptop. Printing labels in word is. For info about merging data with labels, see Create mailing labels in Word by using mail merge or Mail merge in Word for Mac. Follow the simple steps and create your own mailing labels today. Auto-populate a sheet of labels with text pulled from a list. In Colleague go to DOC. In the following article, we tackle some frequently asked questions related to mail merge and step-out how to create mail merge labels in every version of Microsoft Word. Normal Word Document - removes any attached data file. Go to Mailings > Start Mail Merge > Labels. Word, Mail Merge; Word, Mail Merge Recipient List; Microsoft Office Support, Field Codes: Skip If Field. ) You can create a label template from scratch. You can even use our labels for marking food, books and school supplies. Mail Merge and OneNote. Open Word and select "Mailings" from the toolbar ribbon. Click the Table->Show Gridlines menu item. Difficulty:ModerateInstructions Microsoft Word InstructionsLaunch the Microsoft Word application and open a blank document. However, I have two issues: 1. If you are creating labels using the Mail Merge feature, however, the labels may not appear to be centered vertically. Fabian4 recommends that you use the Microsoft Word Mail Merge feature to generate your address labels. Click on the "Mailings" tab, select "Start Mail Merge" and choose "Labels. 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. You can print labels from Excel for multiple contacts directly in Microsoft Word. use template in word com address labels best of resume re templates hi res avery for 5160 mail merge. I’m trying to recreate a form in Word to do the mail merge. Hit the enter key again, insert City, hit the comma key, and the space bar, insert State, hit the space bar again, and insert Zip Code. Basically you will end up bringing all the info from your excel document into the word document. Then I can turn the cards over, and print 100 different recipient addresses (along with my return address) on those 25 sheets using Mail Merge within Writer (Word) and Calc (Excel). How do I import it to word so when I do a mail merge I see it in the l Word Importing Avery Labels - Microsoft: Office - Tek-Tips. Find the DDE for Excel. Time to create Mailing Labels? If so, did you know that your Microsoft Office Word has its own label wizard app, which is very powerful for designing and creating labels, including mail merge? How to Create Mailing Labels in Word. Microsoft Publisher® was created to, well, Publish. Click on Label Options. If you use Avery A4 products, such as labels, business cards, dividers and name badges you can design them using the Avery Templates within in Word. Other topics include customizing labels with graphics, printing electronic postage, and dealing with common printing errors. Begin with a blank document. You can also select New Label if you want to enter custom label dimensions. I am not certain but I do not think the program is working properly. Mail Merge for Dummies: Creating Address Labels in Word 2007 - select the contributor at the end of the page - The Mail Merge function in Word 2007 can be a huge time saver, whether you're creating address labels, letters or other documents that require the input of data from a spreadsheet. WHERE DO I FIND THE TEMPLATE FOR AVERY 5567 TABS. Mail Merge Options - OS X. Mail Merge Tips from Experience. 30 thoughts on “ Mail Merge Address Labels in the Excellent Free LibreOffice ” Piotr March 8, 2012 at 11:03 am. Whether they're for your company or for personal use, our labels will give distinction to your mail. Each placeholder corresponds to one entry such as first name, last name, salutation, city etc. Follow these steps: Start a new blank document. However if you have Excel then you must have Word as well and there you can create a Mail Merge (Tools/MailMerge Manager) and import a CSV file from your Excel data. Prepare Mail Merge for Label Printing. Select Change document layout. First click on Create New which will reveal a drop down menu. Start Mail Merge in the Start Mail Mergegroup on the Mailings tab. Word adds blank labels to a new document. For example, you might want to create mailing labels from the customer information stored in a Visual FoxPro table. But before you can get started with designing, you need the template. Many people know that you can use the Mail Merge feature in Microsoft Word 2010 to easily create mailing labels, but did you know you can use it to quickly create custom name badge inserts? Here, you will learn the steps to create custom name badges with the Mail Merge feature. For details about making labels in Word, see Create and print labels. I am an expert in mail merge who can do following: Mailing/Shipping Labels (Avery, Xerox, or Custom). The Label Options dialog box. In essence, when you mail merge labels from Excel to Word, the column headers of your Excel sheet become placeholders in a Word document denoting the mail merge fields. 0 Mac Label Maker with most of the Avery labels and cards formats support and powerful mail merge feature. In Colleague go to DOC. org to register for classes. The choices > in > the label options are different in Word 2007 and I am having trouble > finding > an equivalent. How to print on Avery Labels that are not A4 in size. Click Add to create a custom merge field. ' In Word 2010, select 'Start Mail Merge' from the 'Mailings' tab and select 'Labels. An Ultimate collection of Free Microsoft Word Templates are presented here to help our visitors in their daily tasks. dotm file, I created a Mail Merge using the. Avery will soon be retiring their Add-in wizard in Word. Skilled in Labels, Microsoft Excel, Customer Service, Sales, and Inventory Management. If you’d prefer to print labels in Excel instead of Microsoft Word, or if you want to do a Mail Merge to MS Word, there are specific steps you need to follow to ensure the merge goes smoothly. ' The label dialog box appears. On the Tools menu, click Mail Merge Manager. This action populates the entire sheet, duplicating exactly what you placed in the first cell — including graphics. In the Label Options dialog box, choose your label supplier in the Label vendors list. Tutorial: Creating barcode labels with Microsoft Word Mail Merge Using Morovia barcode fonts and included VBA module, you can easily create barcode labels. Instructions. intended for people who want to print the i-fax. When the sheet is printed, you have a bunch of labels for your peeling-and-sticking pleasure. The Label Options dialog box appears. Fill the Labels radio button In the Task Pane. Avery templates in MS Word 2013 (Office 365) - posted in Business Applications: I think we have been over this infuriating topic before. Create and print product labels using mailbox merge. I am trying to create labels from Outlook contacts list using Avery 5260 labels, 30 per sheet, 1"x2 5/8" and can't figure it out. If the Mail Merge toolbar isn't showing, point at one of the toolbars, right-click your mouse, and select Mail Merge from the pop-up menu that appears. Open Word 2003 and click on Tools \ Letters and Mailings \ Mail Merge… In the Mail Merge menu on the right under Select document type, select Labels. Here is the guide, using an example of labels. Whether they're for your company or for personal use, our labels will give distinction to your mail. > In Word 2007, using an existing merge document and Access data, I am unable > to use the "update labels" command to make changes in the label format. ' In Word 2010, select 'Start Mail Merge' from the 'Mailings' tab and select 'Labels. It's simple to import names, addresses and other data in just a few quick steps. Word adds blank labels to a new document. The reason they appear this way is because Word often adds some extra empty paragraphs at the end of each label. 0 Mac Label Maker with most of the Avery labels and cards formats support and powerful mail merge feature. Using Word and Excel to create Avery 5160 labels. In Microsoft Word, on the Office Ribbon, click Mailings, Start Mail Merge, and then labels. If you're like a lot of people, your "filing" is a disorganized mess. Add With oDoc. Design a Pages merge document with only one label field, and only one set of merge links. avery 5267 template word 2013 with page 4 of. Click on the Mail Merge button on the Home tab. To do this in Word 2002 or in Word 2003, point to Letters and Mailings on the Tools menu, and then click Envelopes and Labels. Word; Press F5 to build and to run the program. This action populates the entire sheet, duplicating exactly what you placed in the first cell — including graphics. Word 2013: Creating Address Label using Templates First you will need to know what type of label you have purchased. Importing data is great for address labels, invitations, personalized meeting materials or party bags, and name tags or name badges. If you are using the Word 2003 PIA, remove the comment notation for the additional parameter for the Open method. MS Word has provided the Mail Merge facilities to resolve this problem. On the Tools menu, click Mail Merge Manager. At the bottom of the Mail Merge Contacts dialog, make sure you set the "Document type" to: Mailing Labels. Tutorial: Creating barcode labels with Microsoft Word Mail Merge Using Morovia barcode fonts and included VBA module, you can easily create barcode labels. Click the 'Start Mail Merge' wizard. When mail merging in Word to Avery 8160/8150 labels only the first row appears, I know I'm doing it correctly as it works on another computer. A "fast" option is also available to use with dot-matrix printers which bypasses Windows and prints raw text directly to the printer. Print your Outlook contacts as mailing labels. How to Mail Merge and print labels in Microsoft Word. For example, in Figure 10 the selected field is Name. Hit the Merge to New Document or Merge to Printer buttons on the Mail Merge toolbar to create your labels. MAIL MERGE AND WORD 2007. The actual content (appearing on your labels) should be included below each heading. Select the first soft return, shown selected. i selected the avery tent > card template 5309 and i inserted the merge fields but word was only showing > me every other name on the tent cards. I downloaded the Avery Wizard and tried to merge with a Contacts list exported from gmail. This is a quick tutorial on performing an Address Label Mail Merge using a Microsoft Word 10 Address Label Template as a Primary merge document*, and Microsoft Excel worksheet containing a list of. In the Merge Options section, choose Mailing Labels from the Document Type list. In the Mail Merge Manager, click Create New under Select document, and then click. If creating labels by downloading the file from Super, it will already have headings. Word will convert your table to labels without any problem and maintain the label boundaries; therefore, Excel by itself is not suited to the task of creating labels, but Excel with Mail Merge in Word works just fine. Please view this video to familiarize yourself with the everchanging interface of Google Analytics, learn how to pull reports, and more!. Continue reading →. After I use Mail merge to create labels in Word 2007, if I click Save, the number of labels per page reduces to 4 instead of 6. Finding the template first is. Could you please tell me how can I run the Mail Merge for such Avery Label templates. In the Label Information section, choose the Label Vendor 'Avery. Then select Next: Starting document from the bottom of the menu. A button in Excel is linked to RunMailMerge() as below. In this first demo of a 4-part series, learn how to set up labels for mass mailings using the Mail Merge feature in Word 2007. Are you trying to create address labels in Word The Mail Merge function in Word 2007 can be a huge time saver, whether you're creating address labels, letters or other documents that require the input of data from a spreadsheet. These tips will help with creating address or return address labels for business letters, company invoices, wedding invitations, name tags, and more. Whether they're for your company or for personal use, our labels will give distinction to your mail. then click or find the mail merge tab. applied tips : march 2009 microsoft word : aligning labels with ease. Net app, I want to read in a load of addresses from a database and then use word to create address labels on an Avery template L7163 which is then printed to the printer. (The illustration if. [Solved + Issue] Mail merge using Avery labels by Last Chance » Mon Dec 17, 2007 5:24 pm Much as I like to support open source applications, I am getting to the end of my tether with the mail merge facility on Writer. How to print Avery Mailing labels in Word? Printing Individual Labels or a Full Sheet of the same label. In Colleague go to DOC. Click OK to send the labels directly to the printer. No Matter what kind of label template you are looking for, these avery labels will suit your purpose. Download the Fabian4 Address Labels Mail Merge Template for Avery L7160. Click Button1 to start Word Automation and to perform the mail merge. I used to work for a national corporation and only 3 of us could make labels. By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. In essence, when you mail merge labels from Excel to Word, the column headers of your Excel sheet become placeholders in a Word document denoting the mail merge fields. After an easy one-time setup, using the plug-in is quite easy, just need to select in Microsoft Word the merge fields that you want to use, and then we take care of the rest. Click New Document. In the Mail Merge Manager, under 6.