Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-20-2015, 09:56 AM
accessnewbie352 accessnewbie352 is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 64bit
Novice
Saving Merged Files into Sep Docs By Name and into PDF
 
Join Date: Jan 2015
Posts: 3
accessnewbie352 is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 01-21-2015, 03:41 AM
gmayor's Avatar
gmayor gmayor is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
  #3  
Old 01-22-2015, 12:58 AM
macropod's Avatar
macropod macropod is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by accessnewbie352 View Post
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.
Did you look at the Mailmerge Tips & Tricks thread at the top of this forum (https://www.msofficeforums.com/mail-...ps-tricks.html)? It has a macro, under the heading Send Mailmerge Output to Individual Files, for doing exactly that...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 01-23-2015, 09:10 AM
accessnewbie352 accessnewbie352 is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 64bit
Novice
Saving Merged Files into Sep Docs By Name and into PDF
 
Join Date: Jan 2015
Posts: 3
accessnewbie352 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Did you look at the Mailmerge Tips & Tricks thread at the top of this forum? It has a macro, under the heading Send Mailmerge Output to Individual Files, for doing exactly that...
Yes - I did, however the macro only works if there are no section breaks and I have multiple breaks in my mail merge template.
Reply With Quote
  #5  
Old 01-23-2015, 09:12 AM
accessnewbie352 accessnewbie352 is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 64bit
Novice
Saving Merged Files into Sep Docs By Name and into PDF
 
Join Date: Jan 2015
Posts: 3
accessnewbie352 is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
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.
Thank you - the first link is actually exactly what I need and I love the functionality to be able to save the output by a certain field. However, I am on a Work computer and not allowed to download the add-in. Is there a non-download option that is available?
Reply With Quote
  #6  
Old 01-23-2015, 12:39 PM
macropod's Avatar
macropod macropod is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by accessnewbie352 View Post
Yes - I did, however the macro only works if there are no section breaks and I have multiple breaks in my mail merge template.
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]
Reply With Quote
  #7  
Old 06-19-2015, 08:59 AM
Scott1667 Scott1667 is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 64bit
Novice
 
Join Date: Jun 2015
Posts: 4
Scott1667 is on a distinguished road
Default 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!
Reply With Quote
  #8  
Old 06-19-2015, 03:46 PM
macropod's Avatar
macropod macropod is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #9  
Old 06-19-2015, 09:18 PM
gmayor's Avatar
gmayor gmayor is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Quote:
Originally Posted by Scott1667 View Post
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.
If you are referring to the add-in from my web site linked in my original reply, you need to configure the Acrobat printer driver as described in the Adobe Acrobat section of the web page or use the Office PDF function.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #10  
Old 07-01-2015, 02:23 PM
Scott1667 Scott1667 is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 64bit
Novice
 
Join Date: Jun 2015
Posts: 4
Scott1667 is on a distinguished road
Default

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?
Reply With Quote
  #11  
Old 07-01-2015, 03:08 PM
macropod's Avatar
macropod macropod is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #12  
Old 07-02-2015, 06:41 AM
Scott1667 Scott1667 is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 64bit
Novice
 
Join Date: Jun 2015
Posts: 4
Scott1667 is on a distinguished road
Default

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.
Reply With Quote
  #13  
Old 07-02-2015, 06:53 AM
gmayor's Avatar
gmayor gmayor is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
  #14  
Old 07-02-2015, 07:33 AM
gmayor's Avatar
gmayor gmayor is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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.
Reply With Quote
  #15  
Old 07-02-2015, 01:14 PM
Scott1667 Scott1667 is offline Saving Merged Files into Sep Docs By Name and into PDF Windows 7 64bit Saving Merged Files into Sep Docs By Name and into PDF Office 2010 64bit
Novice
 
Join Date: Jun 2015
Posts: 4
Scott1667 is on a distinguished road
Default

The update worked perfectly. Thank you!
Reply With Quote
Reply

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 Files into Sep Docs By Name and into PDF Saving merged document as separate files blankblank Mail Merge 1 05-11-2012 03:36 PM
Saving Merged Files into Sep Docs By Name and into PDF 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:06 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft