A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

mailmerge to labels using Word 2007



 
 
Thread Tools Display Modes
  #1  
Old June 16th, 2009, 04:22 AM posted to microsoft.public.word.mailmerge.fields
Kat
external usenet poster
 
Posts: 268
Default 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  
Old June 16th, 2009, 05:56 AM posted to microsoft.public.word.mailmerge.fields
Susan Baker
external usenet poster
 
Posts: 1
Default 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  
Old June 16th, 2009, 10:26 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default 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  
Old June 17th, 2009, 12:28 AM posted to microsoft.public.word.mailmerge.fields
Dina
external usenet poster
 
Posts: 54
Default 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  
Old June 17th, 2009, 07:54 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.