Tablet PC 2005 SP3 and Word 2007 Mail Merge

[Phil F]

I have a tablet computer with Tablet PC 2005 SP3 and Office 2007 Enterprise
installed. When I try to run a mail merge to create labels, only the top
row of 3 labels and the bottom row two right-side labels populate with
<<NextRecord>><<AddressBlock>> when the "update labels" icon is clicked.
All other label fields on the page are not updated and do not produce labels
when the merge is completed. The problem described in the following KB
article:
http://support.microsoft.com/kb/898630

When I used to have Office 2003 installed, the work around described in the
article worked for a Word 2003 mail merge. Since I upgraded to Office 2007
Enterprise, the work around DOES NOT WORK for a Word 2007 mail merge on a
Tablet PC 2005 SP3 computer.

Help.

Also posted in the microsoft.public.windows.tabletpc group.

Phil F

 

[Doug Robbins - Word MVP]

Hi Phil,

Here is a 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

 

[Phil F]

Doug,

Thanks. I will try the macro.

I have Office 2007.

Which folder do I use to store the template with the macro?

C:\Documents and Settings\user_name\Application Data\Microsoft\Word\Startup
or
C:\Program Files\Microsoft Office\Office12\Startup

Do I simply save a blank document as a template with the macro included and
give the file the name of the macro?

Will all users of the computer be able to access the macro?


I appreciate your help.

Phil F

 

[Doug Robbins - Word MVP]

Hi Phil,

Create the macro in a file (The file can be blank, but you might want to
type into it a description of its purpose) and then save it as a Word
Macro-Enabled Template (.dotm) in

C:\Documents and Settings\user_name\Application Data\Microsoft\Word\Startup

The name that you give to the template does not matter, but probably good to
call is something like LabelMergeMacro.dotm

It is the name of the macro that is important if you want it to run
automatically when you click on the Update Labels item in the Write &
Insert Fields section of the Mailings tab of the Ribbon.

Also 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/MacrosVBA/CreateAMacro.htm


--
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

 

[Phil F]

Doug,

The macro works great. Nice work!

1. What happens to the native MailMergePropagateLabel macro included in word
when you replace it with one such as yours? Is it still available if you
delte your macro?
2. Why does this quirk only affect the Tabpet PC?
3. I have a quirk that affects the Tabpet PC with Outlook 2007 Business
Contact Manager. See below.
Setup: Outlook 2007 with Business Contact Manager integrated with Microsoft
Office Accounting 2008 Professional on a Windows XP SP3 Tablet with 1GB ram
1Ghz processor
using MS Exchange 2000 on a SBS 2000 server with the latest service packs.

The History tab on the Show menu in BCM does not work in either the
Account or Business Contact folder even though a New History Item such as a
phone log has been created. The Phone Log will however show up in the
Communications History folder. When I click the History tab, nothing
happens (the created history items do not appear to be linked to the
business contact or to the appropriate account. This problem appears only
to happen on the Tablet PC 2005 SP3 computer.

Could a macro maybe help this problem?

Phil F

 

[Doug Robbins - Word MVP]

Hi Phil,

The native MailMergePropagateLabel utility is hard coded into the program
and is not a macro. Any of Word's Commands can be usurped by creating a
macro with the same name. If a macro with the name of a Word command is
deleted, then the native command will once again be enabled.

We do not know why the particular issue with the propagation of labels only
affects a Tablet PC (or a regular PC with some Tablet functionality via an
add-on program). I am not sure if anyone at Microsoft does either.

Reur BCM issues, sorry, I do not have the necessary setup to be able to
replicate that issue and try and find a solution. There are however a
couple of other newsgroups to which you might post the question

microsoft.public.outlook.bcm
microsoft.public.windows.tabletpc newsgroup

--
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

 

[Phil F]

Doug:

Thanks for all of your help. Microsoft PSS solved my Outlook 2007 BCM
problem. It was not related to the Tablet PC OS.

Phil F