the mail merge is not working in my microsoft office

I have windows vista, and microsoft office 2007. I use a wacom tablet. I have
tried to go through the mail merge process with both tablet and mouse here;
as well as at someone elses computer strictly using a mouse. I get to the
point where I am to update all labels, and all that gets populated is the top
three labels, and the bottom few on the page. I am not new to mail merge, but
sure can't figure this one out.--
Shelly

Hi Shelly,

There is an issue with the propagation of the label set up when using a
Tablet PC (and also it appears when running under Vista with some other
hardware configurations. Microsoft have been made aware of the issue and
have created a Knowledge Base article at:

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

which does contain a work around.

A better work around however is to use the following macro that I created 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

"Shelly" wrote in message
...
I have windows vista, and microsoft office 2007. I use a wacom tablet. I
have
tried to go through the mail merge process with both tablet and mouse
here;
as well as at someone elses computer strictly using a mouse. I get to the
point where I am to update all labels, and all that gets populated is the
top
three labels, and the bottom few on the page. I am not new to mail merge,
but
sure can't figure this one out.--
Shelly

I have read this article, and maybe I am not understanding it. I am assuming
a tablet pc is where the entire monitor is a tablet? I have a wacom 6x9 table
top tablet. I do not understand what a "tablet PC input panel is, so I get
stuck right then and there with the instructions. I do appreciate the help
however, and would be grateful if the discussion could go further.
--
Shelly


"Doug Robbins - Word MVP" wrote:

Hi Shelly,

There is an issue with the propagation of the label set up when using a
Tablet PC (and also it appears when running under Vista with some other
hardware configurations. Microsoft have been made aware of the issue and
have created a Knowledge Base article at:

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

which does contain a work around.

A better work around however is to use the following macro that I created 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

"Shelly" wrote in message
...
I have windows vista, and microsoft office 2007. I use a wacom tablet. I
have
tried to go through the mail merge process with both tablet and mouse
here;
as well as at someone elses computer strictly using a mouse. I get to the
point where I am to update all labels, and all that gets populated is the
top
three labels, and the bottom few on the page. I am not new to mail merge,
but
sure can't figure this one out.--
Shelly

Don't worry about the terminology. This bug occurs on some ordinary PCs
also. Simply run the macro and see if that helps - if you don't know what to
do with Doug's code - see http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Shelly wrote:
I have read this article, and maybe I am not understanding it. I am
assuming a tablet pc is where the entire monitor is a tablet? I have
a wacom 6x9 table top tablet. I do not understand what a "tablet PC
input panel is, so I get stuck right then and there with the
instructions. I do appreciate the help however, and would be grateful
if the discussion could go further.

Hi Shelly,

There is an issue with the propagation of the label set up when
using a Tablet PC (and also it appears when running under Vista with
some other hardware configurations. Microsoft have been made aware
of the issue and have created a Knowledge Base article at:

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

which does contain a work around.

A better work around however is to use the following macro that I
created 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

"Shelly" wrote in message
...
I have windows vista, and microsoft office 2007. I use a wacom
tablet. I have
tried to go through the mail merge process with both tablet and
mouse here;
as well as at someone elses computer strictly using a mouse. I get
to the point where I am to update all labels, and all that gets
populated is the top
three labels, and the bottom few on the page. I am not new to mail
merge, but
sure can't figure this one out.--
Shelly