How can I mail-merge 1400 labels on 100 sheets of label forms?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RPI Marketeer - 17 Jan 2008 23:20 GMT

I can't get the mail-merge function on MS Office 2007 to print continuous
address labels from an excel spreadsheet onto a single sheet of paper - it
will let me print only one label per page or either the page full of only one
address label. This wastes a lot of paper and time.
Does anyone have any suggestions on how to accomplish what I want to do?

Reply to this Message

Doug Robbins - Word MVP - 18 Jan 2008 06: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

Mail merge has not changed in Word 2007, so determine what it is that you
are doing (or not doing) compared to the information that is given in that
article.

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 can't get the mail-merge function on MS Office 2007 to print continuous
> address labels from an excel spreadsheet onto a single sheet of paper - it
> will let me print only one label per page or either the page full of only
> one
> address label. This wastes a lot of paper and time.
> Does anyone have any suggestions on how to accomplish what I want to do?

Reply to this Message

Graham Mayor - 18 Jan 2008 07:20 GMT

There is also a Word 2007 version of this page on my web site -
http://www.gmayor.com/merge_labels_with_word_2007.htm

Signature

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

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

> See the article "Mailmerge Labels with Word XP" on fellow MVP Graham
> Mayor's website at
[quoted text clipped - 12 lines]
>> Does anyone have any suggestions on how to accomplish what I want to
>> do?

Reply to this Message