how to print address labels from excel 2007

Write the letter and add custom fields.

Selecting Edit recipient list opens up the Mail Merge Recipients dialog box, where you can edit the list and select or unselect records.

Note that now that a list has been created, the Mail Merge Wizard reverts to Use an existing list and you have the option to edit the recipient list.

Create a list by adding data in the New Address List dialog box and clicking OK.

In this demo we will create a new list, so select Type a new list and then click Create. After you choose it, the Mail Merge Wizard reverts to Use the current document.

Note that selecting Start from existing document (which we are not doing in this demo) changes the view and gives you the option to choose your document.

Select Use the current document and then click Next: Select recipients. In this demo we will use the current (blank) document.

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. Mail merge is also used to create envelopes or labels in bulk. Using Mail Merge, you can easily customize form letters for individual recipients. Mail Merge is most often used to print or email form letters to multiple recipients.

How to Use Mail Merge in Microsoft Word See Microsoft Word: Tips and Tricks for similar articles.

How to print address labels from excel 2007