Label problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neil - 04 Aug 2005 02:22 GMT

I posted this problem on another Word newsgroup and got nothing. I'm hoping
I get better luck here. This is the question:

I'm helping a friend print address labels from an Excel sheet as I'm
'supposed to know about computers' but I've never used mail merge before.
By trial and error (and the wizard) I got the end result OK but it was a
long time getting there as the labels had to be created manually and the
column headers matched to the right fields and then the labels formatted
correctly.
He now has a different Excel sheet to make labels from and now I'm stumped.
I saved the previous mail merge and hoped I could use it again and after
going through various screens and pointing it at the right source, the
correct labels show up, but only the first page. There should be at least 3
or 4 pages.
I tried using the wizard route again but each time I end up having to
rematch the fields and reformat the labels.
I'd hoped that using the saved mail merge would work but I'm obvioulsy doing
something wrong. If someone could tell me what I should be doing, I'd be
most grateful.

Office 2003
WinXP SP2

Cheers

Reply to this Message

Doug Robbins - 04 Aug 2005 05:22 GMT

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/mail_merge_labels_with_word_xp.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

>I posted this problem on another Word newsgroup and got nothing. I'm hoping
>I get better luck here. This is the question:
[quoted text clipped - 23 lines]
>
> Cheers

Reply to this Message

Graham Mayor - 04 Aug 2005 05:25 GMT

See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm but it sounds
like you have not completed the merge.

Signature

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

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

> I posted this problem on another Word newsgroup and got nothing. I'm
> hoping I get better luck here. This is the question:
[quoted text clipped - 20 lines]
>
> Cheers

Reply to this Message

Neil - 05 Aug 2005 00:17 GMT

Thanks, I just read the document and I'm still puzzled.

I've read about not 'completing the merge' before but I still can't see
where I 'complete the merge'.
I followed the walkthrough step by step and its just as I did the merge
right up to where I'm supposed to merge to document or printer. At this
point I get just one page of labels and the walkthrough tells me again I
didn't complete the merge. At what point am I not completing the merge?

I'll just add I never used the toolbar, didn't even know there was one!

Thanks.

Reply to this Message

Doug Robbins - 05 Aug 2005 04:57 GMT

I would suggest that you do use the toolbar. It has buttons on it for
executing the merge to the various possible destinations. If you use the
appropriate one of those buttons the merge WILL be executed.

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

> Thanks, I just read the document and I'm still puzzled.
>
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

Graham Mayor - 05 Aug 2005 06:09 GMT

You have to actually merge to document or printer etc to complete the merge.

Signature

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

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

> Thanks, I just read the document and I'm still puzzled.
>
[quoted text clipped - 8 lines]
> one!
> Thanks.

Reply to this Message

Peter Jamieson - 05 Aug 2005 17:50 GMT

if you are using the Mail Merge Wizard and are working with a Label merge,
when you get to "Step 5 of 6" in the Wizard's task pane, you should see the
following options at the bottom of the pane:
Next: Complete the merge
Previous: Arrange your labels

Select the "Next: Complete the merge" option, and you move to Step 6 of
6.But even then, you are not quite done, because you either need to click
the Print... option, which should print the labels, or the "Edit Individual
Labels" option, which really just outputs the merge to a new document, at
which point you can edit the new document as necessary, then print it.

If you're doing a lot of merges, using the toolbar is often quicker once
you've got used to it, as others have doubtless said.

Peter Jamieson

> Thanks, I just read the document and I'm still puzzled.
>
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

Rate this thread: