Creating letters in Microsoft Word from data on an Excel spreadsheet can be done using the Mail Merge feature. The following are steps to take in order to create the letters.
First, make sure to confirm the data in the spreadsheet is prepared for the mail merge. For example, if you want to address the letter recipients by the first name only, you'll want to be sure the first and last names are separated into their own columns.
Next, open Word and start a new, blank document, then take the following steps:
1. Click the Mailings tab, then Start Mail Merge
2. In the group of options that appears, select Letters
3. Next, click Select Recipients, then Use an Existing List
4. You'll then be prompted to select the Excel spreadsheet from the location you saved it to
*NOTE: If you are prompted to select from the table, choose "Sheet1$"
5. Now click Edit Recipient List
6. In the list of recipients, you can remove individuals by deselecting the box
*NOTE: You can also refine the recipient list using sorts, filters, and more.
7. Click the Next button
At this point, you'll need to insert mail merge fields for address information so the document knows who to address the letters to. Take the following steps to insert them:
1. Still in the Mailings tab, click Address Block
2. In the window that appears, select the name format you want for the letter
*NOTE: You can also preview the address on the right to ensure it is how you prefer it.
3. When you've selected your preferences, click OK
At this point, it's a safe step to save the work you've done so far. Click File at the top, then Save, then name the document and save it to a location you'll remember
Now, add a greeting to the letter.
1. Click the Greeting Line option
2. In the window, select your greeting preferences, as well as preview your choices
3. Click OK when ready
Again, save the file.
Next, insert specific data from the Excel spreadsheet into the letter by taking the following steps:
1. Click Insert Merge Fields
2. In the list that appears, select the name field, which will be the column name from the spreadsheet
3. Repeat the process with other merge fields in the list, using only the fields you prefer
You can now preview the letter prior to finishing by clicking the Preview Results option. You can also click through each letter by using the preview options to the right of the Preview Results button.
Finally, when ready, click the Finish & Merge button and select from one of the three options. You can either edit each individual document, print the document, or send it in an email message.
*NOTE: Make sure you save the document after you finish the mail merge. This will allow you to re-use the document for future mail merges.