Hi Dear All

Would you please help me on below case:
I try to use the mail mege spreedsheet data into label L7165
(Avery label type) on A4 paper, my spreedsheet have two columns:
tag_no and item_no, tag_no looks like A001, A002....., so there
should have 8 labels on one A4 page, I follow the mail merge
standard steps to create label L7165, result should looks like
tag_no start from A001 to A008 on the fist page, second page start
tag_no from A009 and end at A016, to my surprise, the second
page start tag_no from A002 and end at A009, the third page start tag_no from A003 and end at A010 and so on.
Would you please extend your hands on this case, it's urgent for Phsical count on July.

Hi stevencheng,

Your problem description suggests you're doing a letter merge instead of the required label merge.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

thanks for your suggestion, I will try if letter merge can meet my requirement, will update you once I test it.

You need to use a label merge.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]