Mailing Labels with Word in Office 2007

  • From: "Jerry Berrier" <jerry.berrier@xxxxxxxxxxx>
  • To: "jfw list" <jfw@xxxxxxxxxxxxx>
  • Date: Mon, 28 Sep 2009 08:01:12 -0400

Hi all,

I'm attempting to create a set of mailing labels from an Excel spreadsheet
in Word.  I've done this hundreds of times in office 2003, and I have
succeeded a few times in Office 2007, but I'm not sure what I did to
succeed.  Most of the time, I end up with either only one address label or
only the first page of labels.  I've followed the exact instructions from
the Word help file for creting labels, and still no luck.

I go to mailings, then start mail merge.  Then I select step by step and
then labels.
I select my label options, I'm using Avery 5160).
Then I select my data source.  It opens, and I hit OK.
Then I insert an address block in the first row, then hit the update all
Then I preview labels, and then complete the merge.
I know I'm missing something, and I'd appreciate any suggestions as to what
I'm missing.  I'd especially like suggestions from a JFW user who is
actually able to do this successfully and consistently.


Jerry Berrier
Access Technology Consultant
108 Bumble Bee Circle
Shrewsbury, MA, 01545
Voice calls and Text (SMS): (508) 735-4420
E-mail: jerry@xxxxxxxxxxxxx

JFW related links:
JFW homepage:
Scripting mailing list:
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to 
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //
Alternative archives located at:

If you have any concerns about the list, post received from the list, or the 
way the list is being run, do not post them to the list. Rather contact the 
list owner at jfw-admins@xxxxxxxxxxxxxx

Other related posts:

  • » Mailing Labels with Word in Office 2007 - Jerry Berrier