![]() In this article, I'll show you how to create the contents-including any graphics and formats- before launching the wizard. Fortunately, there's a super quick remedy. It's extremely easy, but you might have avoided this route because the wizard won't let you insert a logo (graphic file) or otherwise format the content. Word positions each element in the cell of a simple table based on the dimensions and content you provide. ![]() To Word, those items are all the same thing, whether you use a wizard or mail merge to generate them. You can use Word's label wizard to generate business cards, postcards, event tickets, shipping labels, and more. Here are some tips to prepare your Excel spreadsheet for a mail merge.Don't send your printing business out to expensive printers keep it in-house and save money using Word's label wizard. ![]() Make sure:Ĭolumn names in your spreadsheet match the field names you want to insert in your mail merge. For example, to address readers by their first name in your document, you'll need separate columns for first and last names.Īll data to be merged is present in the first sheet of your spreadsheet.ĭata entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values. The Excel spreadsheet to be used in the mail merge is stored on your local machine.Ĭhanges or additions to your spreadsheet are completed before it's connected to your mail merge document in Word.įor more information, see Prepare your Excel data source for mail merge in Word. For more info, see Data sources you can use for a mail merge.įor more info, see Mail merge: Edit recipients.įor more info on sorting and filtering, see Sort the data for a mail merge or Filter the data for a mail merge.Or copy the link! How To? – How To Print Address Labels Using Mail Merge In Word Connect and edit the mailing listĬonnect to your data source. Template Tuesday Presents.how to use Mail Merge to create individual address labels. 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. You can use an Excel Spreadsheet, Outlook Contact List, Office Address List, Word Data File, Access Database, or Text File. Ideally, you should use a compatible template that is built into Word. If your label size doesn’t have a compatible code, you will need a saved copy of a suitable Word label template OR the measurements of your A4 labels. Word label templates and measurements for all of our label sizes can be found in our Label Templates section. We recommend using Word’s STEP BY STEP MAIL MERGE WIZARD and this guide will show you how to use the Wizard to create your set of address labels. #HOW TO MAIL MERGE LABELS FROM EXCEL TO WORD USING WIZARD HOW TO# Click on START MAIL MERGE and select STEP BY STEP MAIL MERGE WIZARD.Ĭlick on the MAILINGS tab at the top of the page. This opens the Mail Merge Wizard panel on the right hand side of your screen. This panel will guide you through the SIX STEPS of the mail merge. ![]() MAIL MERGE: STEP 1 – SELECT DOCUMENT TYPE You will primarily use this panel to set up your address labels. MAIL MERGE: STEP 2 – SELECT STARTING DOCUMENT To create a set of address labels, you will need to select LABELS from the list of documents. This is where you select your label template. As mentioned above, you can use a compatible template, a Word template you have previously downloaded and saved, or create a new label template.Ĭompatible Template – select CHANGE DOCUMENT LAYOUT and click on LABEL OPTIONS. Set “Printer Information” to “Page Printers” and choose your “Label Vendor” (e.g. A4/A5) and click OK.Ĭreate A Label Template – follow the steps above but instead of choosing a code, click on NEW LABEL. Fill in the measurements of your label size and layout, then click OK to create your label template. We’ve written a Template Tuesday guide to creating label templates, which you can view here. Saved Label Templates – select START FROM EXISTING DOCUMENT and click on OPEN. This is where you select your data source (list of addresses).īrowse to your saved label template and open it. You can use an existing list, saved Outlook contacts, or type a new list at this moment. To open an existing list, click on “Use an existing list”, and then browse to and open your saved address list. #HOW TO MAIL MERGE LABELS FROM EXCEL TO WORD USING WIZARD HOW TO#.
0 Comments
Leave a Reply. |