1. How To Do A Mail Merge From Excel To Word For Labels

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. 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.

Personalize names, addresses, and much more in bulk email or documents. Any data stored in an Excel workbook can be used to personalize communications.

Note: These steps only cover what's shown in this video. For detailed steps on how to do a mail merge, please see Mail merge using an Excel spreadsheet.

Use an Excel spreadsheet for mail merge contacts

1. Open the Word document that you want to mail merge.

2. Select Mailings > Select Recipients.

3. Select Use an Existing List.

4. Select the Excel spreadheet you want to use, and select Open.

5. Select the worksheet that you want to use, and select OK.

   Each worksheet name ends with $.

6. Select Edit Recipient List to view the data source, select the checkboxes for the people you want to send to, and select OK.

7. Save your Word file, to save the connections you've made.

How To Do A Mail Merge From Excel To Word For Labels

If you have any questions, come by the Help Desk at Hardman & Jacobs Undergraduate Learning Center Room 105, call 646-1840, or email us at help@nmsu.edu.