Mail Labels Multiple Pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pelican - 28 Mar 2006 00:19 GMT

When I create Mail Labels using Merge and an Excel db, I only end up seeing
the first page of Mail Labels. How do I get the succeeding pages?

On the Select Recipients it shows Sheet 1, then Sheet 1_, then Sheet 2 and
Sheet 3, but when I create the list only sheet 1 shows up.

Reply to this Message

Pelican - 28 Mar 2006 00:42 GMT

By the way - I think that the "Sheet 1_" could be the problem, but I can't
get rid of it.

> When I create Mail Labels using Merge and an Excel db, I only end up seeing
> the first page of Mail Labels. How do I get the succeeding pages?
>
> On the Select Recipients it shows Sheet 1, then Sheet 1_, then Sheet 2 and
> Sheet 3, but when I create the list only sheet 1 shows up.

Reply to this Message

Doug Robbins - Word MVP - 28 Mar 2006 05:12 GMT

Sounds like you have not actually executed the merge. As for the Sheets I
assume that you are referring to the Sheets in the Excel file and you need
to select the sheet that contains the data.

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

> When I create Mail Labels using Merge and an Excel db, I only end up
> seeing
> the first page of Mail Labels. How do I get the succeeding pages?
>
> On the Select Recipients it shows Sheet 1, then Sheet 1_, then Sheet 2 and
> Sheet 3, but when I create the list only sheet 1 shows up.

Reply to this Message

Pelican - 28 Mar 2006 20:01 GMT

I tried it with the same results. I have Word 2003, so it kind of does most
of this stuff in a slightly different way. Anyway, I saved the labels (3
pages). I call them up, and it only shows the first page. If I tell it to
go to 'label 31' it will jump to the second page - so in a way I can kind of
get all three pages - one page at at time. It seems like there should be a
way to print/show all three pages. (If I do 'print' it still only prints the
page showing. Sort of inconvenient.)

> Sounds like you have not actually executed the merge. As for the Sheets I
> assume that you are referring to the Sheets in the Excel file and you need
[quoted text clipped - 11 lines]
> > On the Select Recipients it shows Sheet 1, then Sheet 1_, then Sheet 2 and
> > Sheet 3, but when I create the list only sheet 1 shows up.

Reply to this Message

Doug Robbins - Word MVP - 29 Mar 2006 05:10 GMT

There is. You EXECUTE the mail merge. Word 2003 is NO different to Word XP
in this respect.

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 tried it with the same results. I have Word 2003, so it kind of does
>most
[quoted text clipped - 28 lines]
>> > and
>> > Sheet 3, but when I create the list only sheet 1 shows up.

Reply to this Message

Pelican - 29 Mar 2006 19:38 GMT

AAAAH!!! If all else fails - read the instructions. One little thing.
Worked just fine. Can't thank you enough.

> There is. You EXECUTE the mail merge. Word 2003 is NO different to Word XP
> in this respect.
[quoted text clipped - 31 lines]
> >> > and
> >> > Sheet 3, but when I create the list only sheet 1 shows up.

Reply to this Message

Graham Mayor - 29 Mar 2006 06:46 GMT

You have not completed the merge. You are viewing the merge source document.
Read the linked page again. Where there are differences between Word 2002
and 2003 the page mentions them.

Signature

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

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

> I tried it with the same results. I have Word 2003, so it kind of
> does most of this stuff in a slightly different way. Anyway, I saved
[quoted text clipped - 29 lines]
>>> Sheet 2 and Sheet 3, but when I create the list only sheet 1 shows
>>> up.

Reply to this Message