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.