Help!

Mail Merge Labels in Word 2007

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Formating Long Docs RSS
Next:  Inserting Freehand dawings into Word 2007  
Author Message
Dennis Hughes
External


Since: Nov 07, 2004
Posts: 53



PostPosted: Fri Mar 23, 2007 9:51 pm    Post subject: Mail Merge Labels in Word 2007
Archived from groups: microsoft>public>word>formatting>longdocs (more info?)

I loaded Office 2007 and am trying to do a mail merge to labels using the
step by step commands.

All goes normally until I get to "update all labels". Only the top labels
in each column are "replicated".

I end up with the two top labels on each page, but many pages.

Is this a bug or am I missing something?

I'm running Vista and using Avery US 5162.

Thanks,

Dennis
Back to top
Advertisement
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Sat Mar 24, 2007 6:07 pm    Post subject: Re: Mail Merge Labels in Word 2007
Archived from groups: per prev. post (more info?)

Are you using a Tablet PC?

If so, see the Knowledge Base article at:

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

A workaround for the problem is included.


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

"Dennis Hughes" wrote in message

>I loaded Office 2007 and am trying to do a mail merge to labels using the
>step by step commands.
>
> All goes normally until I get to "update all labels". Only the top labels
> in each column are "replicated".
>
> I end up with the two top labels on each page, but many pages.
>
> Is this a bug or am I missing something?
>
> I'm running Vista and using Avery US 5162.
>
> Thanks,
>
> Dennis
Back to top
Dennis Hughes
External


Since: Nov 07, 2004
Posts: 53



PostPosted: Mon Mar 26, 2007 11:24 am    Post subject: Re: Mail Merge Labels in Word 2007
Archived from groups: per prev. post (more info?)

I'm using a new Dell, normal size. I also tried Mailmerge using the normal
way, not the step by step, and the same result.

The computer is up to date with the Microsoft updates.

Thanks,

Dennis

"Doug Robbins - Word MVP" wrote in message

> Are you using a Tablet PC?
>
> If so, see the Knowledge Base article at:
>
> http://support.microsoft.com/kb/898630
>
> A workaround for the problem is included.
>
>
> --
> 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
>
> "Dennis Hughes" wrote in message
>
>>I loaded Office 2007 and am trying to do a mail merge to labels using the
>>step by step commands.
>>
>> All goes normally until I get to "update all labels". Only the top
>> labels in each column are "replicated".
>>
>> I end up with the two top labels on each page, but many pages.
>>
>> Is this a bug or am I missing something?
>>
>> I'm running Vista and using Avery US 5162.
>>
>> Thanks,
>>
>> Dennis
>
>
Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Mon Mar 26, 2007 2:03 pm    Post subject: Re: Mail Merge Labels in Word 2007
Archived from groups: per prev. post (more info?)

I assume that you are using the Update Labels button in the Write & Insert
Fields chunk of the Mailings tab that appears when a mail merge main
document is active.

It certainly works here on a Dell Latitude D610, running Word 2007 under
Windows XP SP2.

I guess there is a possibility that Vista has introduced a new wrinkle, but
before I try and escalate the problem, can you report back and confirm that
what you are doing is what I have described above. Also, please advise the
exact hardware specification.

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

"Dennis Hughes" wrote in message

> I'm using a new Dell, normal size. I also tried Mailmerge using the
> normal way, not the step by step, and the same result.
>
> The computer is up to date with the Microsoft updates.
>
> Thanks,
>
> Dennis
>
> "Doug Robbins - Word MVP" wrote in message
>
>> Are you using a Tablet PC?
>>
>> If so, see the Knowledge Base article at:
>>
>> http://support.microsoft.com/kb/898630
>>
>> A workaround for the problem is included.
>>
>>
>> --
>> 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
>>
>> "Dennis Hughes" wrote in message
>>
>>>I loaded Office 2007 and am trying to do a mail merge to labels using the
>>>step by step commands.
>>>
>>> All goes normally until I get to "update all labels". Only the top
>>> labels in each column are "replicated".
>>>
>>> I end up with the two top labels on each page, but many pages.
>>>
>>> Is this a bug or am I missing something?
>>>
>>> I'm running Vista and using Avery US 5162.
>>>
>>> Thanks,
>>>
>>> Dennis
>>
>>
>
Back to top
Dennis Hughes
External


Since: Nov 07, 2004
Posts: 53



PostPosted: Tue Mar 27, 2007 3:24 pm    Post subject: Re: Mail Merge Labels in Word 2007
Archived from groups: per prev. post (more info?)

Doug,

I'm using a Dell Dimension DXP061 2.4GHZ Intel dual cord, 4 GB RAM, Vista
home premium, & Office 2007.
I don't understand this line but it save "Tablet PC functionality:
Available"

There are the steps I am taking:
Open MS word
Mailings
Start Mail Merge
Labels
Avery USLetter 5162
Select Recip
Use existing list
Select an xls file
Select Sheet 1$
[Now the next records appear on the screen, two columns, 7 rows]
Edit recip List
Insert Merge Field (in upper left label)
Insert First Name Last Name
Address
City, State Zip
Update Labels
Only the top row and the bottom row are updated, rows 2-6 have only the
"next record"
Preview Document (same results)
Finish the merge (Only rows 1 & 7 have the info in them)

I have an XP machine with Office 2003 and it merges the same xls file
normally.

Hope this helps,

Dennis

"Doug Robbins - Word MVP" wrote in message

>I assume that you are using the Update Labels button in the Write & Insert
>Fields chunk of the Mailings tab that appears when a mail merge main
>document is active.
>
> It certainly works here on a Dell Latitude D610, running Word 2007 under
> Windows XP SP2.
>
> I guess there is a possibility that Vista has introduced a new wrinkle,
> but before I try and escalate the problem, can you report back and confirm
> that what you are doing is what I have described above. Also, please
> advise the exact hardware specification.
>
> --
> 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
>
> "Dennis Hughes" wrote in message
>
>> I'm using a new Dell, normal size. I also tried Mailmerge using the
>> normal way, not the step by step, and the same result.
>>
>> The computer is up to date with the Microsoft updates.
>>
>> Thanks,
>>
>> Dennis
>>
>> "Doug Robbins - Word MVP" wrote in message
>>
>>> Are you using a Tablet PC?
>>>
>>> If so, see the Knowledge Base article at:
>>>
>>> http://support.microsoft.com/kb/898630
>>>
>>> A workaround for the problem is included.
>>>
>>>
>>> --
>>> 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
>>>
>>> "Dennis Hughes" wrote in message
>>>
>>>>I loaded Office 2007 and am trying to do a mail merge to labels using
>>>>the step by step commands.
>>>>
>>>> All goes normally until I get to "update all labels". Only the top
>>>> labels in each column are "replicated".
>>>>
>>>> I end up with the two top labels on each page, but many pages.
>>>>
>>>> Is this a bug or am I missing something?
>>>>
>>>> I'm running Vista and using Avery US 5162.
>>>>
>>>> Thanks,
>>>>
>>>> Dennis
>>>
>>>
>>
>
>
Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Wed Mar 28, 2007 2:05 am    Post subject: Re: Mail Merge Labels in Word 2007
Archived from groups: per prev. post (more info?)

Back to top
Dennis Hughes
External


Since: Nov 07, 2004
Posts: 53



PostPosted: Wed Mar 28, 2007 7:51 am    Post subject: Re: Mail Merge Labels in Word 2007
Archived from groups: per prev. post (more info?)

Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Thu Mar 29, 2007 12:43 pm    Post subject: Re: Mail Merge Labels in Word 2007
Archived from groups: per prev. post (more info?)

Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Fri Mar 30, 2007 2:37 am    Post subject: Re: Mail Merge Labels in Word 2007
Archived from groups: per prev. post (more info?)

Back to top
Sludge



Joined: Apr 17, 2008
Posts: 1



PostPosted: Fri Apr 25, 2008 3:28 pm    Post subject:

For Doug Robbins.
I have used the macro for solving my problem which was exactly the same as Dennis Hughes and it worked perfectly. Wish I was that clever!
Thank you very much indeed.
David Sharp UK
Back to top
KristinaH



Joined: Oct 15, 2008
Posts: 1



PostPosted: Wed Oct 15, 2008 8:41 pm    Post subject: Label Trouble

I am having a different problem merging labels. The merge is populating all of the label fields, however when it goes on to a second page, rather than continuing down the list, it deletes the first person's name, shifts each name over one cell, and adds one name in the last cell. For example if I had John A., John B., and John C. on page 1, I end up with John B., John C. and John D. on page 2; and John C., John D, and John E. on page 3, etc. Rather than having all of my labels on 2 pages, I have 40 pages strange duplication. Any suggestions. The macro doesn't help with this.

Thanks,
Kristina
Back to top
Advertisement
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Formating Long Docs
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum