Merging Avery 5160 labels from excel to word

[ashleygf]

I am attempting to merge contents from Excel 2013 to Avery 5160 labels in Word 2013. From 'start mail merge' I can achieve 30 labels per sheet manually. However, when I record and run a macro, using the same key strokes as when entering manually, the end result prints one label per page (30 pages) instead of 30 labels on the one sheet. Below is the recorded macro. I hope somebody can point me in the right direction and tell me where I am going wrong.
Regards.

Please Login or Register  to view this content.

[Nisha Dhawan]

Hi,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button).

Thanks
Nisha

[ashleygf]

Thank you Nisha, My apologies, am learning all the time.

Regards,
Ashley