Create Mailing Labels in MS Word Using Excel Named Range

How to use Microsoft Excel 2007 with Word 2007
Create and print mailing labels in MS Word Using a named Range in Excel

You can create an address list as a named range in Excel 2007 which can be used to create labels for a mass mailing using mail merge in Word 2007. The process involves basically two steps:

  • Prepare the worksheet data in Excel for the mail merge
  • Configure the labels for the mail merge in Word

Watch the video below to see how the process is implemented.