How can I automate the mail merge process in word for making labels using the 5160 Avery template?

[zrobles]

I am trying to create a macro in word that would run a mail merge using the 5160 US Avery template for labels.

The macro would extract the data from an Excel file and populated into the 5160 Avery template filling the whole page as needed.

The problem I'm having when I run my macro is that it display a single label on separate pages.



In other words it does not populate the whole page. The code that can make this happen would be very much appreciated.