How To Do A Mail Merge From Excel To Word



Mail Merge is most often used to print or email form letters to multiple recipients. Using Mail Merge, you can easily customize form letters for individual recipients. Mail merge is also used to create envelopes or labels in bulk.

  1. How To Do A Mail Merge From Excel To Word Doc
  2. Setting Up Excel Spreadsheet For Mail Merge

How To Do A Mail Merge From Excel To Word Doc

Create mailing labels from excel spreadsheet

This feature works the same in all modern versions of Microsoft Word: 2010, 2013, and 2016.

  1. In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail Merge group, click Start Mail Merge.

  2. Click Step-by-Step Mail Merge Wizard.

  3. Select your document type. In this demo we will select Letters. Click Next: Starting document.

  4. Select the starting document. In this demo we will use the current (blank) document. Select Use the current document and then click Next: Select recipients.
    • Note that selecting Start from existing document (which we are not doing in this demo) changes the view and gives you the option to choose your document. After you choose it, the Mail Merge Wizard reverts to Use the current document.

  5. Select recipients. In this demo we will create a new list, so select Type a new list and then click Create.
    • Create a list by adding data in the New Address List dialog box and clicking OK.

    • Save the list.

    • Note that now that a list has been created, the Mail Merge Wizard reverts to Use an existing list and you have the option to edit the recipient list.

    • Selecting Edit recipient list opens up the Mail Merge Recipients dialog box, where you can edit the list and select or unselect records. Click OK to accept the list as is.

    • Click Next: Write your letter.

  6. Write the letter and add custom fields.
    • Click Address block to add the recipients' addresses at the top of the document.

    • In the Insert Address Block dialog box, check or uncheck boxes and select options on the left until the address appears the way you want it to.
    • Note that you can use Match Fields to correct any problems. Clicking Match Fields opens up the Match Fields dialog box, in which you can associate the fields from your list with the fields required by the wizard.


  7. Press Enter on your keyboard and click Greeting line... to enter a greeting.

  8. In the Insert Greeting Line dialog box, choose the greeting line format by clicking the drop-down arrows and selecting the options of your choice, and then click OK.

  9. Note that the address block and greeting line are surrounded by chevrons (« »). Write a short letter and click Next: Preview your letters.

Create your Excel Spreadsheet. The most important step in the mail merge process is to set up. Go to Mailings Start Mail Merge E-mail Messages. Step 2: Set up your mailing list The mailing list is your data source. For more info, see Data sources you can use for a mail merge. Learn how to perform a mail merge from Microsoft Excel to Microsoft Word in order to produce mass mailings to a group of people. If you ever need to send for.

  • Preview your letter and click Next: Complete the merge.

    1. In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail Merge group.
    2. Merge Data from an Excel Workbook into a Word Document. Open Microsoft Excel or whichever spreadsheet software you use. (This works with Google Docs’ spreadsheets too). Since we’re creating mailing labels, the data we will be merging will be first name, last name, and address. The first row will be the column headings, so in the first.
    Word

    Setting Up Excel Spreadsheet For Mail Merge

  • Click Print to print your letters or Edit individual letters to further personalize some or all of the letters.