Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Sep 2005
    Location
    North Carolina, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am helping someone that has an excel database using word 2003 to merge and print labels. There are about 20 pages of labels, but using merge only prints first and last page. Any suggestions on what the problem is? You can flip through the merged document and see that all pages are present, the print diag is set to print All.

    thanks

  2. #2
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Dallas, Texas, USA
    Posts
    113
    Thanks
    3
    Thanked 6 Times in 6 Posts
    Your message is a tad confusing. You say that there are 20 pages of labels, but that "merge prints only the first and last." I am a tad confused, because you normally don't use merge twice against the same data. Typically, you either merge directly to the printer, or merge to a new document, then use the regular print function to print the document.

    I usually do the latter, for two reasons. First, it enables me to troubleshoot and validate the merge before I commit to paper. Second, I can save the merged document as a permanent record of the merge operation.

    David Gray, Chief Wizard
    WizardWrx
    Irving, Texas, USA

    WizardWrx Web - Technical Articles and Free Software
    You are more important than any technology we may employ.

  3. #3
    New Lounger
    Join Date
    Sep 2005
    Location
    North Carolina, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The merge either to printer or to document gave the same results, page one and the last page. Ended up creating a new document and resetting up the merge feature and it worked. Not sure what the problem was.

  4. #4
    2 Star Lounger
    Join Date
    Dec 2003
    Location
    Ossining, New York, USA
    Posts
    114
    Thanks
    4
    Thanked 2 Times in 2 Posts
    I'm not sure if this is your problem, but...

    The only process that is not intuitive in a mail merge (in 2003 and newer) is when doing labels. When you are finished adding merge fields to the first label, you must press the Propagate Labels icon on the Mail Merge toolbar in order to have the merge fields in the first label copied to all of the labels.




    I hope this helps.




    Fred



  5. #5
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Dallas, Texas, USA
    Posts
    113
    Thanks
    3
    Thanked 6 Times in 6 Posts
    Fred,

    Quote Originally Posted by redbeard42 View Post
    The only process that is not intuitive in a mail merge (in 2003 and newer) is when doing labels. When you are finished adding merge fields to the first label, you must press the Propagate Labels icon on the Mail Merge toolbar in order to have the merge fields in the first label copied to all of the labels.
    That's an outstanding point!

    It's one that I didn't discover for years, leading me to propagate the labels manually.

    For the benefit of lurkers, the same is true in Word 2002, and probably all previous versions, but it's been too long since the last time I used Word 2000, let alone Word 97 and Word 6, so I cannot say for certain about whether those versions have the propagate labels button.
    David Gray, Chief Wizard
    WizardWrx
    Irving, Texas, USA

    WizardWrx Web - Technical Articles and Free Software
    You are more important than any technology we may employ.

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    The Mail Merge Wizard was revised substantially in Word 2002, and the Propagate Labels button appeared at that time. Prior versions did Mail Merges in quite a different fashion.
    Wendell

  7. #7
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Dallas, Texas, USA
    Posts
    113
    Thanks
    3
    Thanked 6 Times in 6 Posts
    Wendell,

    Quote Originally Posted by WendellB View Post
    The Mail Merge Wizard was revised substantially in Word 2002, and the Propagate Labels button appeared at that time. Prior versions did Mail Merges in quite a different fashion.
    Thanks for adding that detail, and saving me digging out and firing up one of the two old laptop computers that still have working installations of Office 2000. I suppose that it's safe to say, then, that Word 97 behaves more or less like Word 2000, as does (probably) Word 6.
    David Gray, Chief Wizard
    WizardWrx
    Irving, Texas, USA

    WizardWrx Web - Technical Articles and Free Software
    You are more important than any technology we may employ.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •