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 / July 2008

Tip: Looking for answers? Try searching our database.

Tablet PC 2005 SP3 and Word 2007 Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Phil F - 18 Jul 2008 04:40 GMT
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 - 18 Jul 2008 05:43 GMT
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.

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 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
[quoted text clipped - 18 lines]
>
> Phil F
Phil F - 18 Jul 2008 15:42 GMT
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

> Hi Phil,
>
[quoted text clipped - 87 lines]
>>
>> Phil F
Doug Robbins - Word MVP - 18 Jul 2008 22:52 GMT
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

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

> Doug,
>
[quoted text clipped - 113 lines]
>>>
>>> Phil F
Phil F - 19 Jul 2008 00:58 GMT
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

> Hi Phil,
>
[quoted text clipped - 135 lines]
>>>>
>>>> Phil F
Doug Robbins - Word MVP - 19 Jul 2008 09:38 GMT
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

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

> Doug,
>
[quoted text clipped - 166 lines]
>>>>>
>>>>> Phil F
Phil F - 27 Jul 2008 00:41 GMT
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

> Hi Phil,
>
[quoted text clipped - 188 lines]
>>>>>>
>>>>>> Phil F
 
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.