[jstech]

in office 2007, when i try to mail merge an excel file with mail labels in
word 2007, i get the mail merge taking place on the first 3 labels, then it
skips the bulk of the page and merges the last 2 labels. what happened to all
the labels in between? (First labels printed are #s 1, 2, and 3
Last labels printed are 30 and 31. there are multiple labels in between
these, and more labels after.
as far as i can tell the excel sheet is correct.

[Doug Robbins - Word MVP]

I guess that you are using a Tablet PC or a PC with some tablet-like
functionality enabled.

There is a bug in Word that causes 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. Here is a
macro that will overcome the problem:

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

If you do not know what to do with the above code, see the article "What do
I do with macros sent to me by other newsgroup readers to help me out?€� at:

http://www.word.mvps.org/FAQs/Macros...eateAMacro.htm

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,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"jstech" wrote in message
...
in office 2007, when i try to mail merge an excel file with mail labels in
word 2007, i get the mail merge taking place on the first 3 labels, then
it
skips the bulk of the page and merges the last 2 labels. what happened to
all
the labels in between? (First labels printed are #s 1, 2, and 3
Last labels printed are 30 and 31. there are multiple labels in between
these, and more labels after.
as far as i can tell the excel sheet is correct.

[jstech[_2_]]

using a windows 7 machine with office 7. dell studio desktop 9000. no tablet
pc, but I do have a wacom connected (for use in photoshop).
tried macro. don't know what I did , but I kept getting errors, and I could
not save it into a new template - I was not given the ioption to.
still at a standstill.
thanks anyway.
jess

"Doug Robbins - Word MVP" wrote in message
...
I guess that you are using a Tablet PC or a PC with some tablet-like
functionality enabled.

There is a bug in Word that causes 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. Here is
a macro that will overcome the problem:

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

If you do not know what to do with the above code, see the article "What
do I do with macros sent to me by other newsgroup readers to help me out?€�
at:

http://www.word.mvps.org/FAQs/Macros...eateAMacro.htm

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,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services
on
a paid professional basis.

"jstech" wrote in message
...
in office 2007, when i try to mail merge an excel file with mail labels
in
word 2007, i get the mail merge taking place on the first 3 labels, then
it
skips the bulk of the page and merges the last 2 labels. what happened to
all
the labels in between? (First labels printed are #s 1, 2, and 3
Last labels printed are 30 and 31. there are multiple labels in between
these, and more labels after.
as far as i can tell the excel sheet is correct.

[Doug Robbins - Word MVP]

The Wacom would do it.

What sort of errors did you get?

In the VBE editor, do any of the lines of code appear in a red font?

If they are, that would be because the mail program has introduced line
breaks that should not be there.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"jstech" wrote in message
...
using a windows 7 machine with office 7. dell studio desktop 9000. no
tablet pc, but I do have a wacom connected (for use in photoshop).
tried macro. don't know what I did , but I kept getting errors, and I
could not save it into a new template - I was not given the ioption to.
still at a standstill.
thanks anyway.
jess

"Doug Robbins - Word MVP" wrote in message
...
I guess that you are using a Tablet PC or a PC with some tablet-like
functionality enabled.

There is a bug in Word that causes 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.
Here is a macro that will overcome the problem:

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

If you do not know what to do with the above code, see the article "What
do I do with macros sent to me by other newsgroup readers to help me
out?€� at:

http://www.word.mvps.org/FAQs/Macros...eateAMacro.htm

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,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services
on
a paid professional basis.

"jstech" wrote in message
...
in office 2007, when i try to mail merge an excel file with mail labels
in
word 2007, i get the mail merge taking place on the first 3 labels, then
it
skips the bulk of the page and merges the last 2 labels. what happened
to all
the labels in between? (First labels printed are #s 1, 2, and 3
Last labels printed are 30 and 31. there are multiple labels in between
these, and more labels after.
as far as i can tell the excel sheet is correct.