Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2008

Tip: Looking for answers? Try searching our database.

the mail merge is not working in my microsoft office

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Shelly - 03 Apr 2008 02:01 GMT
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
Doug Robbins - Word MVP - 03 Apr 2008 04:14 GMT
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.

Signature

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

>I have windows vista, and microsoft office 2007. I use a wacom tablet. I
>have
[quoted text clipped - 7 lines]
> sure can't figure this one out.--
> Shelly
Shelly - 03 Apr 2008 05:12 GMT
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.
Signature

Shelly

> Hi Shelly,
>
[quoted text clipped - 85 lines]
> > sure can't figure this one out.--
> > Shelly
Graham Mayor - 03 Apr 2008 07:01 GMT
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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> 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
[quoted text clipped - 101 lines]
>>> sure can't figure this one out.--
>>> Shelly
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.