If you want to exclude certain recipients, then click the Edit Recipient List button in the Start Mail Merge group. Then, select the target sheet and click OK.īy setting the connection between your Excel sheet and the Word document you ensure that your mail merge data source will be automatically updated each time you make changes to the Excel file that contains the recipient details. Browse for your Excel file and click Open.
![how to merge word documents 2010 how to merge word documents 2010](https://www.computerhope.com/issues/pictures/compareandmerge.jpg)
Connect Excel spreadsheet and Word document.On the Mailings tab, in the Start Mail Merge group, click Select Recipients > Use Existing List. On the Mailings tab, in the Start Mail Merge group, click Start Mail Merge and pick the mail merge type - letters, email messages, labels, envelopes or documents. Choose what kind of merge you want to run.If you have already composed your letter, you can open an existing document, otherwise create a new one. For email messages, the steps will be essentially the same. In this example, we will be merging letters. Once the source data spreadsheet is set and reviewed, you are ready to run the mail merge. Here's an example of an Excel sheet that can be used for a mail merge:
#HOW TO MERGE WORD DOCUMENTS 2010 HOW TO#
#HOW TO MERGE WORD DOCUMENTS 2010 ZIP#
When you run a mail merge, your Excel file will get connected to your Word document, and Microsoft Word will be pulling the recipient details directly from the connected worksheet.īefore running a mail merge in Word, make sure your Excel file has all the information you want to include such as first name, last name, salutation, zip codes, addresses, etc. Preparing Excel spreadsheet for mail merge The goal of the mail merge is to combine the data in File 1 and File 2 to create File 3.
![how to merge word documents 2010 how to merge word documents 2010](http://i.ytimg.com/vi/13ErZxwVecg/maxresdefault.jpg)
This tutorial provides an overview of the main features and explains how to do a mail merge from Excel step-by-step. It lets you quickly create custom letters, emails or mailing labels in Word by merging the information you already have in your Excel spreadsheet.
![how to merge word documents 2010 how to merge word documents 2010](http://apsona.com/assets/sfdc/doc/emailMerge/insertWordMergeField.jpg)
Mail Merge can be a real time-saver when it comes to sending mass mailings. This end-to-end tutorial will teach you how to effectively mail merge in Word using an Excel sheet as the data source.