mailmerge to labels using Word 2007

[KAT]

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?

 

[Susan Baker]

Kat,

Do you have a tablet PC? This is a known issue, with a workaround here

http://support.microsoft.com/kb/898630

 

[Doug Robbins - Word MVP]

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

 

[Dina]

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?

 

[Peter Jamieson]

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