Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2017, 07:53 AM
beefcake2000 beefcake2000 is offline Save mailmerge records as individual word files using VBA Windows 7 64bit Save mailmerge records as individual word files using VBA Office 2010 64bit
Novice
Save mailmerge records as individual word files using VBA
 
Join Date: Nov 2017
Posts: 10
beefcake2000 is on a distinguished road
Default Save mailmerge records as individual word files using VBA

Hi all,

I made a Word mailmerge document that uses input from an Excel document. I would like to save every row/record as an individual word or pdf file, which is named after the value of one of the input fields of the Excel document (file number). Is there a way to do this in a bulk merge using VBA?



Thanks!
Paul
Reply With Quote
  #2  
Old 11-10-2017, 10:19 AM
Souriane Souriane is offline Save mailmerge records as individual word files using VBA Windows 7 64bit Save mailmerge records as individual word files using VBA Office 2013
Advanced Beginner
 
Join Date: Feb 2017
Location: Quebec, Canada
Posts: 82
Souriane is on a distinguished road
Default

Hi!

Allen Wyatt has written on that topic here :
https://word.tips.net/T001538_Mergin...ual_Files.html


Souriane
Reply With Quote
  #3  
Old 11-10-2017, 12:55 PM
macropod's Avatar
macropod macropod is offline Save mailmerge records as individual word files using VBA Windows 7 64bit Save mailmerge records as individual word files using VBA 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

See Send Mailmerge Output to Individual Files in the Mailmerge Tips and Tricks Sticky thread at the top of the Mailmerge forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 11-10-2017, 09:55 PM
gmayor's Avatar
gmayor gmayor is offline Save mailmerge records as individual word files using VBA Windows 10 Save mailmerge records as individual word files using VBA Office 2016
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

You may also find
http://www.gmayor.com/individual_merge_letters.htm. or

http://www.gmayor.com/MergeAndSplit.htm useful
__________________
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save mailmerge records as individual word files using VBA Send Mailmerge Output to Individual Files - troubleshooting help mxk372 Mail Merge 1 07-06-2017 03:49 PM
Save mailmerge records as individual word files using VBA Mailmerge - when some records have photos, and some without smitty777 Mail Merge 3 05-20-2016 08:30 PM
Save mailmerge records as individual word files using VBA Missing records after word mailmerge matthewchin Mail Merge 18 12-11-2015 12:06 AM
Save mailmerge records as individual word files using VBA Trouble doing a Mailmerge in Word 2010 with multiple records for the same client Merlot Mail Merge 2 12-07-2015 10:13 AM
Save mailmerge records as individual word files using VBA Mailmerge Individual Documents DaddyMac Mail Merge 4 06-06-2013 09:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:53 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