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: Newest
Most helpful Newest Oldest
  1. Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
    2015-01-26T09:56:18+00:00

    Yes, it does work in Office 2007.

    At what point do you get that error message?

    If you want to send me a copy of the mail merge main document and the data source, I will check them out.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-01-26T09:50:01+00:00

    Dear Doug,

    Thank you for the tool.

    Will this work with office 2007?

    I am able to put all of my setting for attachment, however i keep getting "Cannot find this file. Verift the path and file name are correct."

    Thanks!

    Was this answer helpful?

    0 comments
  3. Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
    2015-01-17T09:37:09+00:00

    It would be possible to modify the add-in to save the documents that it produces in any of the following formats:

    Contact me by email if you need a customized version.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2015-01-17T09:02:47+00:00

    Hi All,

    The Addins always worked fine...

    It also depends what you want as the final version/type of the file and also the source database shall be well defined/formatted.

    I successfully used the merge addin to output MS Word DocX files from a CSV source data file.

    I then had to open each DocX to save them as 'Normal' Web Page HTM files as the addin  could only produce 'Filtered' HTM Files.

    I wanted to produce a Macro for the save to normal web Htm file but still did not find time to create it.

    Doug, please see if you have anything in mind to output Normal Htm files.

    Cheers,

    Regards,

    Muzafar

    Was this answer helpful?

    0 comments
  5. Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
    2015-01-17T07:15:41+00:00

    I do not recall if Stanzip sent a file to me.  However, if you are having a problem with my MergeTools add-in, do send me the files with a description of the problem and I will investigate the issue.

    Was this answer helpful?

    0 comments