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 implememnted.