Solved

Microsoft Publisher - Publishing Mail Merge to Acrobat Professional

Posted on 2013-01-03
18
1,052 Views
Last Modified: 2014-02-10
I have a two page Microsoft Publisher  document, that I have mail merged with a csv file.

There are about 500 of these two page documents -- that I want to Print to Adobe Acrobat Pro.

I can print a single two page document to Acrobat pro -- but I cannot seem to be able to print all 500 of these documents to a single Acrobat Pro document.  I do that simply by going to File > Print Merge -- and telling it to print just one "Entry".

I want to send the the entire 500-entry acrobat file to send to Kinkos  so they can print it.  I want just one acrobat pro file with all of the 500 entries.  (FYI -- They are 2 page mail-merged letters that we are mailing via U.S. Mail....)

However, when I try to use the same File > Print Merge -- and telling it to print all the entries -- using Acrobat Professional as the "Printer".  Microsoft Publisher tries to print each two page document individually -- causing a mess.

Any suggestions?

Thanks

Rowby
0
Comment
Question by:Rowby Goren
  • 11
  • 7
18 Comments
 
LVL 16

Expert Comment

by:terencino
ID: 38742970
Hi Rowby what version of Pro do you have?
Can you print the 500 individual PDF files to a single folder? You could just set the folder in the print settings
If so Acrobat should allow you to create a single PDF from multiple PDFs, either using the PDF Portfolio or Combine files into PDF
Not a one-step process but a bit closer to what you wanted.
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 38743142
Hi

Thanks for responding.  Acrobat Pro CS5.

But each time it wants to print the file it asks me to confirm a file name.  There are actually over 500 files --- about 1,200 files.   Can I turn off the prompt so acrobat will just print out the files -- and then I can, as you suggest, use Pro to combine all the files in that folder?

Thanks

Rowby
0
 
LVL 16

Expert Comment

by:terencino
ID: 38743168
Sure just go to Start > Devices & Printers > Adobe PDF printer > right-click > Printing preferences > Adobe PDF Settings tab > Adobe PDF Output Folder dropdown as shown below. Next to "Prompt for Adobe PDF filename" hit the Browse button to go to the folder you want. Uncheck View Adobe PDF Results. Then OK the dialogs and print away. I assume it generates a new filename for each of the prints from Publisher?
Adobe PDF Printer PreferencesAlso can you tell me what version of Publisher, I was assuming 2010?
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 38743943
Hi

Publisher 2007.

And will double check acrobat settings.....
0
 
LVL 16

Accepted Solution

by:
terencino earned 500 total points
ID: 38745813
If you had Publisher 2003 the follow registry hack would work perfectly without all the hassle with Acrobat, but Microsoft have disabled this for 2007 and onward apparently
Publisher 2010 printing mail merges 1 document at a time
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 38745969
Ah.  That explains it.  I thought I was able to do that before.

I will look around for Office 2003.  Thanks for that tip.

I will get back with the results of my test.

Rowby
0
 
LVL 16

Expert Comment

by:terencino
ID: 38746060
Good luck, if you have volume licensing, then your IT guys will also be able to give you a copy of 2003, 2010 or 2013 now.
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 38762889
Hi  terencino

I got Publisher 2003 from Amazon.   Below is a snipipet from the link you sent.  If I want it to batch print up to 2000 items, do I add =2000  or just the number 2000

What is the format:

For example is this correct:  NumberOfRecordsPerBatch=2000

Thanks


HKEY_CURRENT_USER/SOFTWARE/MIRCROSOFT/OFFICE/11.0/PUBLISHER/PRINTING  

ADD A STRING VALUE: NumberOfRecordsPerBatch then enumerating whatever batch size you would like.

Guess what there is no printing tab under Publisher 2010 (14.0)

    Reply
    Quote
0
 
LVL 16

Expert Comment

by:terencino
ID: 38764604
Hi rowby, wow I didn't think they were around any more.
The value is just 2000, no = sign
Have you modified the registry before?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 9

Author Comment

by:Rowby Goren
ID: 38775911
Yup. I've modified registry before.   Will do it later today and will award points.

So just to be certain, this is what the registry entry needs to look like:


 NumberOfRecordsPerBatch2000
or is it
 NumberOfRecordsPerBatch 2000

Just want to be certain :)

Rowby
0
 
LVL 16

Expert Comment

by:terencino
ID: 38776333
The DWORD is
NumberOfRecordsPerBatch
It's value is 2000
Good luck can you send me a screenshot when you get to it
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 38776380
Will do!
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 38776403
Here's what I entered.  I guess it is okay :)
regedit-publisher-printing.jpg
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 38776421
Tried it and looks like it's publishing.  I have over a 1000 2 page letters.  I'll report back after it finishes.   No more "one PDF document at a time" that screws everything up.
0
 
LVL 16

Expert Comment

by:terencino
ID: 38776578
Great, but there was only 200 in there, not 2000?
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 38776700
Ah!  That's why it only printed 200!.   I'll go into regedit and redo it!
Rowby
0
 
LVL 9

Author Closing Comment

by:Rowby Goren
ID: 38776756
Thanks!  The problem was Microsoft not doing it Q&A and not paying attention to its feedback.  

Microsoft better get their act together or Google's cloud will take over deskop publishing too!


Rowby
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 39848261
Hello all

I installed Windows 8.1 and reinstalled Publisher 2003 so I could mailmerge more than 20 pages at a time to Acrobat Pro.  

Just to clarify for anyone else wondering how to do this.  Here is a screen shot of my modified registry.  As you can see I set the quantity of Acrobat Page printing to a maximum of 10 trillion I think!
publsiher-registry-print.jpg
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article focuses on how to remove password security from multiple PDF files by Adobe Acrobat program. Sometimes it is essential to access the stored data items and to print, edit as well as copy content from Portable Document Format files in abs…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Sometimes we receive PDF files that are in the wrong orientation. They may be sideways or even upside down. This most commonly happens with scanned or faxed documents. It is possible to rotate the view of these PDFs with the free Adobe Reader produc…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now