Mail Merge woes

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • D_L_P
    Self Employed

    1,000+ Posts
    • Oct 2009
    • 1196

    #1

    Mail Merge woes

    I have a customer doing a mail merge with about 2000+ addresses on a Savin 8055. It works on their old computer a P4 with WinXP and publisher ver10.0 (2003? maybe?) but their new computer an AMDx2 64 WinXP and publisher ver 12.0 (2007?) it won't print right. They print a 11x17 newsletter with individual address on each print. The problem is there are 2 sets stapled together, or it only prints the 1st address on every print depending on which driver you use.

    What I've done so far is try PCL6, PCL5e, and RPCS (Ricoh's own driver). Before it would not staple at all and spit them out the top tray, but when I set it to "Start Printing After Last Page is Spooled" it will now saddle stitch and fold like its supposed to but there are 2 sets stapled together.

    I had to edit the registry per an article on Microsoft's knowledge base to get Publisher 10.0 to work but 12.0 doesn't have a place to change it. They can use their old dinosaur (P4) of a computer to get it to print, but I thought I'd ask the pro's here for any ideas.
  • Mr Spock
    Vulcan Inventor of Death

    1,000+ Posts
    • Aug 2006
    • 2064

    #2
    Publisher sends a mail merge job as 1 set regardless of how many it may actually be. If you google publisher mail merge you will find an article from a tech in great britain who wrote a process for fixing this using a macro. I would start there and try it..

    Here is a link to another person with the same question.

    How do I print multiple mail merge contacts per page
    And Star Trek was just a tv show...yeah right!

    Comment

    • TheOwl
      Service Manager

      Site Contributor
      1,000+ Posts
      • Nov 2008
      • 1733

      #3
      Try this Mail Merge Macro.

      It will break the merge down into separate jobs instead of your office programs sending everything as 1 big job.
      Attached Files
      Please don't ask me for firmware or service manuals as refusal often offends.

      Comment

      • TheOwl
        Service Manager

        Site Contributor
        1,000+ Posts
        • Nov 2008
        • 1733

        #4
        See if any of this helps.
        Attached Files
        Please don't ask me for firmware or service manuals as refusal often offends.

        Comment

        • sdrawkcab
          Confused & Bewildered

          250+ Posts
          • Jun 2009
          • 317

          #5
          To adjust the settings for 12, the registry change needs to be made under HKEY_LOCAL_MACHINE not CURRENT_USER as the microsoft article says.
          Some days, it's just not worth chewing through the restraints

          Comment

          • D_L_P
            Self Employed

            1,000+ Posts
            • Oct 2009
            • 1196

            #6
            Woohoo!
            I will give that a try. I wondered why 12 didn't have that key.

            Comment

            • ajefferson

              #7
              Re: Mail Merge woes

              I am having this issue and have been for years. I bought Page Plus X9 to see if that would fix it but it still staples my newsletters together. I'm using Windows 7 Professional and I have Office 2013.



              Originally posted by D_L_P
              I have a customer doing a mail merge with about 2000+ addresses on a Savin 8055. It works on their old computer a P4 with WinXP and publisher ver10.0 (2003? maybe?) but their new computer an AMDx2 64 WinXP and publisher ver 12.0 (2007?) it won't print right. They print a 11x17 newsletter with individual address on each print. The problem is there are 2 sets stapled together, or it only prints the 1st address on every print depending on which driver you use.

              What I've done so far is try PCL6, PCL5e, and RPCS (Ricoh's own driver). Before it would not staple at all and spit them out the top tray, but when I set it to "Start Printing After Last Page is Spooled" it will now saddle stitch and fold like its supposed to but there are 2 sets stapled together.

              I had to edit the registry per an article on Microsoft's knowledge base to get Publisher 10.0 to work but 12.0 doesn't have a place to change it. They can use their old dinosaur (P4) of a computer to get it to print, but I thought I'd ask the pro's here for any ideas.

              Comment

              Working...