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

Hi!

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


Souriane

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]

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