Impressive Mail Merge Labels From Excel To Word

The mail merge process creates a sheet of mailing labels that you can print and each label on the sheet contains an address from the list.

Mail merge labels from excel to word. Create your address labels In Word click Mailings Start Mail Merge Step-by-Step Mail Merge Wizard to start the mail merge wizard. Mail merge displays next recordI am merging an excel spreadsheet to word to print labels. Complete the merge Perform the merge In the Mail Merge task pane verify that the Complete the merge step is displayed.

How do I do a mail merge. If you use Microsoft Office you can easily import addresses or other data from an Excel spreadsheet and place them onto Avery labels name badges name tags or other products to edit and print using Microsoft Word. The field code will look something like MERGEFIELD fieldname.

The Merge to new document dialog box appears so that you can select which records to merge. To create and print the mailing labels you must first prepare the worksheet data in Excel and then use Word to configure organize review and print the mailing labels. With the mail merge main document open press Alt F9 to view the field codes.

The Match Fields window will appear. Directly after the end quote around the field name type followed by. 0 for rounded whole numbers.

Once your mailing addresses are set up in an Excel spreadsheet see the previous video to learn how its a snap to get Word to create mailing labels from them. Create a sheet of Avery mailing labels from an Excel worksheet of names and addresses. Use Mail Merge to produced labels.

See the steps to mail merge onto an Avery template making preparing for mailings and meetings a breeze. To print labels from Excel you need to prepare your worksheet set up labels in Microsoft Word then connect the worksheet to the labels. In essence when you mail merge labels from Excel to Word the column headers of your Excel sheet become placeholders in a Word document denoting the mail merge fields.