how to mail merge labels from excel to word office 2010

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. Connect and edit the mailing listĬonnect to your data source. 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. Summary How to print labels in Word 2010. Step 9: Click the New Document button at the bottom of the window if you want to see the sheet before you print the labels, or click the Print button if you just want to start printing. 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. Step 8: Click the OK button to close the Label Options window. Make sure:Ĭolumn names in your spreadsheet match the field names you want to insert in your mail merge. Make sure that Outlook is set as your computer’s default email program.Here are some tips to prepare your Excel spreadsheet for a mail merge. In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail Merge group, click Start Mail Merge. This feature works the same in all modern versions of Microsoft Word: 2010, 2013, and 2016. Select the right-most icon to generate email message. Mail merge is also used to create envelopes or labels in bulk. Make sure your personalization inserts have worked properly with the recipient list. For each personalization aspect in your email, place the cursor in the correct location, then select the corresponding field and click “Insert.”

If you added any personalization aspects in Step 1, select “More items…” on this screen. This was completed in Step 1, but you can make any adjustments to the e-mail message now as well. Optionally filter or sort recipients if you would like to send the message to only a portion of those in the Excel file by selecting “Edit recipient list.'

Select “Use an existing list” then browse for the file created in Step 2. The Mail Merge task pane appears and will guide you through the six main steps to complete a merge. Selecting Step by Step Mail Merge Wizard. Having already opened the drafted email, select “Use the current document,” then click next. To use Mail Merge: Open an existing Word document, or create a new one.

Select the radio dial for “E-mail messages” and click next at the bottom of the sidebar.

Open the Word document created in Step 1 and follow the step-by-step below in Word’s Mail Merge Manager under Tools > Mail Merge Manager.

How to mail merge labels from excel to word office 2010