Microsoft Office Forums - View Single Post - [Solved] How can I automate the mail merge process in word for making labels using the 5160 Avery template?

macropod · 08-06-2015, 05:31 PM

So far, there is nothing in what you've posted or attached that indicates you need anything more than a mundane label merge. At the very least, you should start off by properly populating & formatting the first label. You can then use Word's 'update labels' button to populate the rest. While it's possible to do all of that with a macro, that approach is far harder to maintain than is an ordinary label mail merge main document. Is there a reason you can't use a pre-formatted label mail merge main document? After doing the basic setup (whether manually or programmatically), you could, of course, automate Word from Excel to run the mailmerge, or drive the process with a Word macro, but you haven't provided any details or code that suggests how you're trying to either. For example, where is this 'button' meant to be - in Word or in Excel?