Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Label - Mail Merge - Word 2007
I have a data source of 100 rows.
My word document - label format - contains 4 rows each page. When I do the mail merge; each label sytax reads as follows: «Next Record»«CUSTOMER_NAME» «CONTACT_DETAILS» For some reason, the merged data that comes repeats itself.. If the 1st page has row 1, 2, 3 and 4... then the 2nd page has rows 2, 3, 4 and 5... the 3rd page has rows 3, 4, 5 and 6... I dont want it this way.. I want the labels to continue the sequence... 1st page - rows 1, 2, 3 and 4 2nd page - rows 5,6,7 and 8 and so on.. I tried using merge sequence #... but it still isnt working. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Label - Mail Merge - Word 2007
If each label in the mail merge main document has the «Next Record» field,
then this should not be happening. Are you sure that field appears in each label after the first? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Fuzzy" wrote in message ... I have a data source of 100 rows. My word document - label format - contains 4 rows each page. When I do the mail merge; each label sytax reads as follows: «Next Record»«CUSTOMER_NAME» «CONTACT_DETAILS» For some reason, the merged data that comes repeats itself.. If the 1st page has row 1, 2, 3 and 4... then the 2nd page has rows 2, 3, 4 and 5... the 3rd page has rows 3, 4, 5 and 6... I dont want it this way.. I want the labels to continue the sequence... 1st page - rows 1, 2, 3 and 4 2nd page - rows 5,6,7 and 8 and so on.. I tried using merge sequence #... but it still isnt working. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Label - Mail Merge - Word 2007
If each label in the mail merge main document has the «Next Record» field,
then this should not be happening. Are you sure that field appears in each label after the first? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Fuzzy" wrote in message ... I have a data source of 100 rows. My word document - label format - contains 4 rows each page. When I do the mail merge; each label sytax reads as follows: «Next Record»«CUSTOMER_NAME» «CONTACT_DETAILS» For some reason, the merged data that comes repeats itself.. If the 1st page has row 1, 2, 3 and 4... then the 2nd page has rows 2, 3, 4 and 5... the 3rd page has rows 3, 4, 5 and 6... I dont want it this way.. I want the labels to continue the sequence... 1st page - rows 1, 2, 3 and 4 2nd page - rows 5,6,7 and 8 and so on.. I tried using merge sequence #... but it still isnt working. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Label - Mail Merge - Word 2007
Almost certainly you have not completed the merge. You must complete the
merge either to a new document or to the printer. See http://www.gmayor.com/merge_labels_with_word_2007.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Fuzzy" wrote in message ... I have a data source of 100 rows. My word document - label format - contains 4 rows each page. When I do the mail merge; each label sytax reads as follows: «Next Record»«CUSTOMER_NAME» «CONTACT_DETAILS» For some reason, the merged data that comes repeats itself.. If the 1st page has row 1, 2, 3 and 4... then the 2nd page has rows 2, 3, 4 and 5... the 3rd page has rows 3, 4, 5 and 6... I dont want it this way.. I want the labels to continue the sequence... 1st page - rows 1, 2, 3 and 4 2nd page - rows 5,6,7 and 8 and so on.. I tried using merge sequence #... but it still isnt working. |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Label - Mail Merge - Word 2007
Almost certainly you have not completed the merge. You must complete the merge either to a new document or to the printer. See http://www.gmayor.com/merge_labels_with_word_2007.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Fuzzy" wrote in message ... I have a data source of 100 rows. My word document - label format - contains 4 rows each page. When I do the mail merge; each label sytax reads as follows: «Next Record»«CUSTOMER_NAME» «CONTACT_DETAILS» For some reason, the merged data that comes repeats itself.. If the 1st page has row 1, 2, 3 and 4... then the 2nd page has rows 2, 3, 4 and 5... the 3rd page has rows 3, 4, 5 and 6... I dont want it this way.. I want the labels to continue the sequence... 1st page - rows 1, 2, 3 and 4 2nd page - rows 5,6,7 and 8 and so on.. I tried using merge sequence #... but it still isnt working. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge label only puts one label per page? | Mailmerge | |||
Label mail merge does not work correctly - Word 2007 | Mailmerge | |||
Mail Merge 2007 - One record per label page | Mailmerge | |||
Word 2007 Label Mail Merge Suppression Issue | Mailmerge | |||
Mail merge with Excel 2007 will not print but 1 label!! | Mailmerge |