If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
mailmerge to labels using Word 2007
I'm merging data from an Excel workbook to create labels, which I have done
hundreds of times in the older versions of Word, however now I cannot get Word 2007 to propagate all of my labels. When I click on the "update labels" button it only propagates the first three and the last two labels on each page (out of 30 labels). I've already rechecked my data source but have found nothing out of the ordinary. Any suggestions? |
#2
|
|||
|
|||
mailmerge to labels using Word 2007
Kat,
Do you have a tablet PC? This is a known issue, with a workaround here http://support.microsoft.com/kb/898630 "KAT" wrote in message ... I'm merging data from an Excel workbook to create labels, which I have done hundreds of times in the older versions of Word, however now I cannot get Word 2007 to propagate all of my labels. When I click on the "update labels" button it only propagates the first three and the last two labels on each page (out of 30 labels). I've already rechecked my data source but have found nothing out of the ordinary. Any suggestions? |
#3
|
|||
|
|||
mailmerge to labels using Word 2007
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 (C:\Users\[user name]\AppData\Roaming\Microsoft\Word\Startup) 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 "KAT" wrote in message ... I'm merging data from an Excel workbook to create labels, which I have done hundreds of times in the older versions of Word, however now I cannot get Word 2007 to propagate all of my labels. When I click on the "update labels" button it only propagates the first three and the last two labels on each page (out of 30 labels). I've already rechecked my data source but have found nothing out of the ordinary. Any suggestions? |
#4
|
|||
|
|||
mailmerge to labels using Word 2007
The exact same thing is happening to me.
i've spent countless hours on tech support with microsoft and they cannot or refuse to help me with this issue. I've read Doug's response, but i am not a "techie", and don't even know what to do with Doug's response. I do not have a tablet pc. I have a desktop with windows vista. I don't understand why microsoft cannot or won't fix this problem??? I'm so frustrated that I cannot perform a simple mail merge to labels, the exact same labels that KAT is using. It' should be computer 101. Any ideas on how a non "techie" can resolve this issue? "KAT" wrote: I'm merging data from an Excel workbook to create labels, which I have done hundreds of times in the older versions of Word, however now I cannot get Word 2007 to propagate all of my labels. When I click on the "update labels" button it only propagates the first three and the last two labels on each page (out of 30 labels). I've already rechecked my data source but have found nothing out of the ordinary. Any suggestions? |
#5
|
|||
|
|||
mailmerge to labels using Word 2007
I have a desktop with windows vista.
This problem can occur on a Vista machine with tablet or some other multimedia functions enabled - even if you just have a pen input device on your system. As far as I know, the only ways to get around this are a. the suggestions in the article referenced by Susan b. a macro as suggested by Doug - there are some instructions on how to use these macros at http://www.gmayor.com/installing_macro.htm c. identify which device is causing the problem and disable it. But since that's likely to require even more "techie" capability than (a) or (b), I'd probably opt for (b). I don't understand why microsoft cannot or won't fix this problem??? Well, most of the people who reply to questions here are volunteers who do not work for Microsoft, so it's difficult to do anything more than speculate, but the main reasons why stuff doesn't get fixed are (a) budgetary (no budget to investigate or fix as other things have a higher priority), (b) can't pin down the cause (which I would doubt in this case) and (c) the "fix" causes a different problem. Personally, I am also surprised that this problem was not fixed before it reached Vista. Peter Jamieson "Dina" wrote in message news The exact same thing is happening to me. i've spent countless hours on tech support with microsoft and they cannot or refuse to help me with this issue. I've read Doug's response, but i am not a "techie", and don't even know what to do with Doug's response. I do not have a tablet pc. I have a desktop with windows vista. I don't understand why microsoft cannot or won't fix this problem??? I'm so frustrated that I cannot perform a simple mail merge to labels, the exact same labels that KAT is using. It' should be computer 101. Any ideas on how a non "techie" can resolve this issue? "KAT" wrote: I'm merging data from an Excel workbook to create labels, which I have done hundreds of times in the older versions of Word, however now I cannot get Word 2007 to propagate all of my labels. When I click on the "update labels" button it only propagates the first three and the last two labels on each page (out of 30 labels). I've already rechecked my data source but have found nothing out of the ordinary. Any suggestions? |
Thread Tools | |
Display Modes | |
|
|