#1
|
|||
|
|||
Saving Merged Files into Sep Docs By Name and into PDF
I have a merged file that consists of 1-page per employee and I would like to find a way to automatically save each page into a separate PDF file using the employee's name as the name of the document.
I realize there might be multiple steps involved and I'm not even sure if such a macro exists between MS Word and Adobe but hoping to eliminate as many steps here as possible. The only way I can think of so far to do this is to save my giant merged file into pdf, use Adobe Acrobat to split the files and then manually go into each file and rename the document name. This takes a lot of time/manual work - is there a way that will allow me to achieve the results faster either through a macro in word or something in Adobe? |
#2
|
||||
|
||||
Take a look at http://www.gmayor.com/individual_merge_letters.htm and http://www.gmayor.com/MergeAndSplit.htm
Both will do what you require. So fast all the work has been done for you However I will echo Microsoft's recommendation that for most users the 32 bit version of Office is the better option.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
||||
|
||||
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
Yes - I did, however the macro only works if there are no section breaks and I have multiple breaks in my mail merge template.
|
#5
|
|||
|
|||
Quote:
|
#6
|
||||
|
||||
That simply isn't true. The number of Section breaks, if any, is of no consequence whatsoever for macro under the heading Send Mailmerge Output to Individual Files. The Mailmerge Tips & Tricks thread also has another macro, under the heading Split Merged Output to Separate Documents, and that one allows you to specify however many Sections there are per letter. Either way, your needs are covered.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Auto Save?
Is there a way to have the PDF's auto save after the first one is save to the correct location?
I am using Acrobat XI and Word 2010, and it opens each PDF then makes me save each PDF one at a time. I simply love this add on and its great, but I am running merges up to 600 letters at a time and the auto close and save would be a huge help. Thank you! |
#8
|
||||
|
||||
The macros in the link I posted automatically output the files to the same folder as the document they're run from, without opening them.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
||||
|
||||
Quote:
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#10
|
|||
|
|||
I am running into a problem when splitting large merges. Basically I do not need the word split and save as much as the PDF itself. From what I can tell Adobe gets ahead of Word and causes a fatal error to happen.
Has anyone else seen this issue? |
#11
|
||||
|
||||
Please clarify whether you're referring to Graham's Addin or the macros in the link I posted.
The macros in the Mailmerge Tips & Tricks thread at the top of this forum (https://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html) use Word's native functions, not anything from Adobe. The macro under the heading Send Mailmerge Output to Individual Files there can produce the PDFs directly, without the need for a document as well.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#12
|
|||
|
|||
I am sorry I am using Graham's Add-on which works great until I hit about 100+ individual files. The error states that Adobe couldn't locate the word doc to make the file. I am assuming that Adobe is working faster than word.
The end result that I need is really just the PDF's. The current doc is almost 800 letters that need to be split. I have the PDF preferences set as indicated. Thank you for the direction on the web page, honestly one of the best sets of instructions I have used in a long time. |
#13
|
||||
|
||||
It is usually the other way around, with Acrobat struggling to keep pace. It could be running out of buffer space. The Office PDF function is faster and doesn't use a 'printer' driver to create the PDFs.
I updated Merge and Split earlier this week. See if the updated version of that add-in fixes the problem for you. This is a simpler process than http://www.gmayor.com/individual_merge_letters.htm but no less effective at what it can achieve.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#14
|
||||
|
||||
Having seen your comment about Acrobat, I have made a small amendment to the add-in to turn off background mode printing to the Adobe driver. I have been testing it with my largest database of over 3000 records and it is well past 200 and still going without problem.
I have put the file on my web site temporarily at http://www.gmayor.com/Forum/MMtoDocs Ver 5.0.dotm. See if this fixes the issue for you. Please let me know if successful so I may update the live version on my web site.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com Last edited by gmayor; 07-02-2015 at 09:41 PM. |
#15
|
|||
|
|||
The update worked perfectly. Thank you!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Text Shifting When Saving Word 2007 Docs | DerekS | Word | 1 | 09-21-2013 02:42 AM |
Saving merged document as separate files | blankblank | Mail Merge | 1 | 05-11-2012 03:36 PM |
Can I automatically save mpp files on a Project Server to 'shard docs' or elsewhere? | dksfwmcc | Project | 3 | 03-19-2012 09:09 AM |
saving a mail merged document after the user edits it. | kosh2 | Mail Merge | 0 | 08-05-2011 03:35 AM |
Icons in the desktop move when saving docs | ryochan | Word | 0 | 09-26-2009 02:12 AM |