#1
|
|||
|
|||
Mail Merge to label L7165X, record can't auto page to next 8 records
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. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
thanks for your suggestion, I will try if letter merge can meet my requirement, will update you once I test it.
|
#4
|
||||
|
||||
You need to use a label merge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
l7165, mail merge labels |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple mail merge records on the same page | allenglishboy | Mail Merge | 3 | 07-18-2012 06:22 AM |
avoid duplicete record and merge the record with the existed record | hemant.behere | Excel | 0 | 01-10-2012 02:53 AM |
Deleting records/results from mail merge | alexb123 | Mail Merge | 2 | 08-12-2011 02:27 PM |
Mail Merge - Many Records for Each Addressee | awalker1970 | Mail Merge | 1 | 12-31-2010 11:52 AM |
Combine Records when Mail Merge from Access | Tom Pickles | Misc | 2 | 08-24-2010 06:00 PM |