Mail Merge Labels

Start a new blank document and save it with the name Mail Merge Labels.

With the Mailing Tab selected click Start Mail Merge then select Labels.

Start Mail Merge

At the Labels Options dialog box change Label information to Avery US Letter and choose 8160. I obtained this information from the Avery Label package. Depending on what labels you purchase will depend on the vender and the product number.

Label Options

Click OK to set the label options.

Connect the Labels to Your Address List:

On the Mailings tab, in the Select Recipients group, Use Existing List.

Select Recipients

Navigate to your student folder and select the access database you created when you were constructing your form letter.

Data Source

Your document should now look like this. Notice that the first label holds no information. That will be our next step:

Labels Page Layout

Add Merge Address Data:

Place your cursor to the right of the Picture/ClipArt. With the Mailing tab selected select Address Block.

Address Block

Click OK to accept the default settings at the Address Block dialog box. FYI:You can preview your recipients at this dialog box. Your document should now look like this:

Address Blcok Added

With the Mailing tab selected click Update Labels to add the Recipients to all your labels.

Update Labels

Your labels should now look like this:

Labels

Preview Labels:

To see how your labels will work, with the Mailing tab selected click Preview Results.

Preview Results

Your labels should now look like this. Your labels should include five different names.

Labels

Finish and Merge

Click Finish and Merge to complete your labels.

Resave your mail merge labels.

Nicholson's Lesson Plan Blues