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.
I have a sheet of Avery labels two across by 5 rows down. I also have the Avery template for those labels downloaded from the Avery web site and wish to use VBA to create address labels from Excel automatically using VBA
In the past I have created Word documents from Excel data using templates and VBA but I am having a lot of difficulty getting data from Excel into these labels using VBA. I have tried using a Word table without success either.
Could you help?
MS Word and Excel are the two important programs of the Microsoft that people use the most. So, if you want to create mailing labels in the MS Word, Yo have to use the Excel first and have to make the worksheet data in that.