Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can only populate 1st row of Avery label 8167
I have 13 records in Excel 2007 and tried merging it to word 2007 using avery
label 8167. I followed the step-by-step mail merge wizard up to the update labels button. When I select Preview results, I only see the first four records on the first row (should I be seeing 13 records?) I check to find recipients yet all 13 are there. Auto check for errors is ok-no errors found. I can't seem to populate the 2nd, 3rd & 4th rows. Please help... |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can only populate 1st row of Avery label 8167
You need to complete the merge. I believe the code for this is "Edit
individual labels." -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Chadvinc" wrote in message ... I have 13 records in Excel 2007 and tried merging it to word 2007 using avery label 8167. I followed the step-by-step mail merge wizard up to the update labels button. When I select Preview results, I only see the first four records on the first row (should I be seeing 13 records?) I check to find recipients yet all 13 are there. Auto check for errors is ok-no errors found. I can't seem to populate the 2nd, 3rd & 4th rows. Please help... |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can only populate 1st row of Avery label 8167
Are you using a Tablet PC, or a computer with some tablet-like capabilities.
If so, here is a macro to overcome the problem with propagation of mail merge field fields with a label type mail merge when using a Tablet PC and some other Computers that have Tablet PC Functionality available: Sub MailMergePropagateLabel() Dim atable As Table Dim i As Long, j As Long Dim source As Cell, target As Cell Dim myrange As Range Set atable = ActiveDocument.Tables(1) Set source = atable.Cell(1, 1) Set myrange = source.Range myrange.Collapse wdCollapseStart ActiveDocument.Fields.Add Range:=myrange, Text:="NEXT", _ PreserveFormatting:=False source.Range.Copy For j = 2 To atable.Columns.Count Set target = atable.Cell(1, j) If target.Range.Fields.Count 0 Then target.Range.Paste End If Next j For i = 2 To atable.Rows.Count For j = 1 To atable.Columns.Count Set target = atable.Cell(i, j) If target.Range.Fields.Count 0 Then target.Range.Paste End If Next j Next i atable.Cell(1, 1).Range.Fields(1).Delete End Sub It is suggested that you put this code into a template that you save in the Word Startup folder so that it becomes an add-in and will be available whenever you need it. As the macro has the same name as the Word Command that is supposed to do the job, this macro will run when the Update Labels button is used when setting up the mail merge label main document. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Chadvinc" wrote in message ... I have 13 records in Excel 2007 and tried merging it to word 2007 using avery label 8167. I followed the step-by-step mail merge wizard up to the update labels button. When I select Preview results, I only see the first four records on the first row (should I be seeing 13 records?) I check to find recipients yet all 13 are there. Auto check for errors is ok-no errors found. I can't seem to populate the 2nd, 3rd & 4th rows. Please help... |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can only populate 1st row of Avery label 8167
Thanks, Suzanne. Exactly how do I use this code in Word 2007?
"Suzanne S. Barnhill" wrote: You need to complete the merge. I believe the code for this is "Edit individual labels." -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Chadvinc" wrote in message ... I have 13 records in Excel 2007 and tried merging it to word 2007 using avery label 8167. I followed the step-by-step mail merge wizard up to the update labels button. When I select Preview results, I only see the first four records on the first row (should I be seeing 13 records?) I check to find recipients yet all 13 are there. Auto check for errors is ok-no errors found. I can't seem to populate the 2nd, 3rd & 4th rows. Please help... . |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can only populate 1st row of Avery label 8167
Thanks, Doug. Yes, I use Red Tablet by Motion Computing. Altho I see a macros
option under the View tab of Word 2007, I have no idea how to use this code or to create a template. I am interested in availing of your services if you have the time. My email is . Thank you for your response. "Doug Robbins - Word MVP" wrote: Are you using a Tablet PC, or a computer with some tablet-like capabilities. If so, here is a macro to overcome the problem with propagation of mail merge field fields with a label type mail merge when using a Tablet PC and some other Computers that have Tablet PC Functionality available: Sub MailMergePropagateLabel() Dim atable As Table Dim i As Long, j As Long Dim source As Cell, target As Cell Dim myrange As Range Set atable = ActiveDocument.Tables(1) Set source = atable.Cell(1, 1) Set myrange = source.Range myrange.Collapse wdCollapseStart ActiveDocument.Fields.Add Range:=myrange, Text:="NEXT", _ PreserveFormatting:=False source.Range.Copy For j = 2 To atable.Columns.Count Set target = atable.Cell(1, j) If target.Range.Fields.Count 0 Then target.Range.Paste End If Next j For i = 2 To atable.Rows.Count For j = 1 To atable.Columns.Count Set target = atable.Cell(i, j) If target.Range.Fields.Count 0 Then target.Range.Paste End If Next j Next i atable.Cell(1, 1).Range.Fields(1).Delete End Sub It is suggested that you put this code into a template that you save in the Word Startup folder so that it becomes an add-in and will be available whenever you need it. As the macro has the same name as the Word Command that is supposed to do the job, this macro will run when the Update Labels button is used when setting up the mail merge label main document. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Chadvinc" wrote in message ... I have 13 records in Excel 2007 and tried merging it to word 2007 using avery label 8167. I followed the step-by-step mail merge wizard up to the update labels button. When I select Preview results, I only see the first four records on the first row (should I be seeing 13 records?) I check to find recipients yet all 13 are there. Auto check for errors is ok-no errors found. I can't seem to populate the 2nd, 3rd & 4th rows. Please help... |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can only populate 1st row of Avery label 8167
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 "Chadvinc" wrote in message ... Thanks, Suzanne. Exactly how do I use this code in Word 2007? "Suzanne S. Barnhill" wrote: You need to complete the merge. I believe the code for this is "Edit individual labels." -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Chadvinc" wrote in message ... I have 13 records in Excel 2007 and tried merging it to word 2007 using avery label 8167. I followed the step-by-step mail merge wizard up to the update labels button. When I select Preview results, I only see the first four records on the first row (should I be seeing 13 records?) I check to find recipients yet all 13 are there. Auto check for errors is ok-no errors found. I can't seem to populate the 2nd, 3rd & 4th rows. Please help... . |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can only populate 1st row of Avery label 8167
By "code" I meant that the link to click in the Mail Merge Wizard (it's not
even a button) has the wording "Edit individual labels," which does not, to my mind, very clearly imply "Complete the merge." -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Chadvinc" wrote in message ... Thanks, Suzanne. Exactly how do I use this code in Word 2007? "Suzanne S. Barnhill" wrote: You need to complete the merge. I believe the code for this is "Edit individual labels." -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Chadvinc" wrote in message ... I have 13 records in Excel 2007 and tried merging it to word 2007 using avery label 8167. I followed the step-by-step mail merge wizard up to the update labels button. When I select Preview results, I only see the first four records on the first row (should I be seeing 13 records?) I check to find recipients yet all 13 are there. Auto check for errors is ok-no errors found. I can't seem to populate the 2nd, 3rd & 4th rows. Please help... . |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change label list from avery 8160 to avery 4103? | Microsoft Word Help | |||
Avery label 8167 leaves off bottom half of city and state | Microsoft Word Help | |||
need bates label template for avery label 5167 | Microsoft Word Help | |||
How do I populate the Label template W\an existing CSV file? | Microsoft Word Help | |||
Avery 8167 Label Template Wrong | Mailmerge |