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. Anonymous
    2013-12-30T04:11:10+00:00

    Hi Graham,

    Your AddIn is a master piece mate... Great Job to you too... The link was on this page itself...

    When i save my myfile.docx as htm format, the htm file works file in web browsers and as Outlook signature.

    Well, your HTM export seems to create filtered HTM format which removes certain formatting.

    • Is it possible to export to normal HTM format instead of Filtered?

    Im a novice in Macros but i managed to compile these:

    1:

    Sub ExportToHTM()

    '

    ' ExportToHTM Macro

    '

    '

    ChangeFileOpenDirectory "H:\00-Public\99-UPDATES\SIGNATURES\DEC2013\DOCX"

    ActiveDocument.SaveAs2 FileName:= _

    "H:\00-Public\99-UPDATES\SIGNATURES\DEC2013\DOCX\ActiveDocument.Filename", FileFormat:= _

    wdFormatHTML, LockComments:=False, Password:="", AddToRecentFiles:=True, _

    WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _

    SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _

    False, CompatibilityMode:=0

    End Sub

    ---++++++++

    2:

    Sub ExportToHTM()

    '

    ' ExportToHTM Macro

    '

    '

    ChangeFileOpenDirectory "H:\00-Public\99-UPDATES\SIGNATURES\DEC2013\DOCX"

    ActiveDocument.SaveAs2  FileName:= _

    "ActiveDocument.Filename", FileFormat:= _

    wdFormatHTML, LockComments:=False, Password:="", AddToRecentFiles:=True, _

    WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _

    SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _

    False, CompatibilityMode:=0

    End Sub

    -----++++++++

    Both scripts do export my docx file to the correct htm format except that the file name is not what's required.

    As i have several docx files, i want the macro to output htm files using the current filename.

    e.g. myfile1.docx to myfile1.htm ;;; myfile2.docx to myfile2.htm

    I am sure you will find a solution for me Graham.

    Cheers to all,

    Muzafar

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2013-12-30T05:33:05+00:00

    It's a simple change to the add-in code

    Use this version instead - https://dl.dropboxusercontent.com/u/57986755/MMtoDocs%20Ver%203.0B.dotm

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2013-12-30T08:34:42+00:00

    That was a super quick reply from Graham.

    Now we can output HTM files (not filtered). thanks for the modifications.

    But please see the files below and guide me how to fix.

    https://skydrive.live.com/embed?cid=6B32D1EE74870BB9&resid=6B32D1EE74870BB9%21616&authkey=AHcKRDc1gJEaeUo

    https://skydrive.live.com/embed?cid=6B32D1EE74870BB9&resid=6B32D1EE74870BB9%21615&authkey=ANYa5p3SBUPHZWU

    You will notice the format/alighment changes when exporting to HTM using the Addin instead of using the basic saveas feature.

    Perhaps just a little fix required.

    You let me know.

    Thank You indeed.

    muzafar

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2013-12-30T13:45:36+00:00

    As I said earlier, HTML format is radically different from Word document format, and PDF is just a graphical representation of the document. 

    Check your formatting in Word web view and fix it before running the merge.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2014-01-13T19:06:55+00:00

    Hello,

    I am trying to do the same thing, and I really like the looks of your tool. I used the Merge to Individual Docs and it worked perfectly for 3 of my 204 merged pages, but then it gave me the following message:

    "13

    Type mismatch."

    And then it stopped merging / saving the files. Do you know what I can do to fix this?

    Thank you!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments