How to Mail Merge to Create Avery Labels in Word

• Download Donor Information
• 1. In the Reports tab under Donors select the first report titled Donor Information and either download it or email it to yourself
  2. Name and save the Excel sheet to your computer
• Start your labels in Word
  1. Open a blank document
  2. Go to Mailings> Start Mail Merge > Labels
  3. Select Avery US Letter as the label vendor
  4. Select the product number of your labels

• Connect the donor information
  1. Go to Select Recipients > Use an Existing List
  2. Select the Excel file you saved to your computer
  3. Make sure the “First row of data contains columns” is checked and click “OK”
•  Format your label
• 1. Go to Mailings> Address Block.
     1. Choose a format for the recipient's name in the Insert Address Block dialog box.

• Update and Preview the labels
  1. Click Update Labels
  2. Click Preview Results
• Finish and Print your Labels
  1. Go to Finish & Merge
  2. Select Print Documents