convert mail merge documents to individual pdf docs

Anonymous
2013-07-29T14:37:50+00:00

I created a mail merge using Word 2010.  It is several documents combined into one large Word file with section breaks.  It is many pages long.

I need to convert it into individual pdf documents.  I have used the vba code bleow with pdf creator with some success.  I now need to do the same thing with E-Copy 5.3

Sub SplitMergeLetterToPrinter()

    Dim Letters As Long, Counter As Long

    Letters = ActiveDocument.Sections.Count

    'MsgBox "Sections counted = " & Letters

    Counter = 1

    While Counter < Letters

        ActiveDocument.PrintOut Background:=False, Range:=wdPrintFromTo, _

            From:="s" & Format(Counter), To:="s" & Format(Counter)

        Counter = Counter + 1

    Wend

End Sub

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

43 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Paul Edstein 82,871 Reputation points Volunteer Moderator
    2016-02-16T12:33:45+00:00

    For macros to both generate the PDFs directly and split mailmerge output documents to separate PDFs, see:

    • Send Mailmerge Output to Individual Files; and

    • Split Merged Output to Separate Documents,

    in the Mailmerge Tips and Tricks threads at:

    http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html

    or:

    http://windowssecrets.com/forums/showthread.php/163017-Word-Mailmerge-Tips-amp-Tricks

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-09-11T08:33:01+00:00

    Hi Doug,

    I haven't installed the tool yet and wanted to know if the tool can save the pdf files based on the desired field in the data source.

    For example the pdf files generated should be saved based on the customer name. i.e Tom Smith.pdf

    Thanks

    Jag

    Was this answer helpful?

    0 comments
  3. Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
    2017-09-12T00:18:54+00:00

    Yes, when you use the facilities, you can select the field that contains the data to be used as the filename.  Note however due to the possibility of two people having the same name, using just the customer name field is not really a good idea as the contents of the field that you choose to supply the field name should be unique.

    Was this answer helpful?

    0 comments