#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hi!
Allen Wyatt has written on that topic here : https://word.tips.net/T001538_Mergin...ual_Files.html Souriane |
#3
|
||||
|
||||
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] |
#4
|
||||
|
||||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Send Mailmerge Output to Individual Files - troubleshooting help | mxk372 | Mail Merge | 1 | 07-06-2017 03:49 PM |
Mailmerge - when some records have photos, and some without | smitty777 | Mail Merge | 3 | 05-20-2016 08:30 PM |
Missing records after word mailmerge | matthewchin | Mail Merge | 18 | 12-11-2015 12:06 AM |
Trouble doing a Mailmerge in Word 2010 with multiple records for the same client | Merlot | Mail Merge | 2 | 12-07-2015 10:13 AM |
Mailmerge Individual Documents | DaddyMac | Mail Merge | 4 | 06-06-2013 09:22 PM |